Question about Microsoft Excel for PC

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Sorry to disappoint you but I will just give you directions to do it yourself.

**Ungrouped**

First sort the data in ascending order (from lowest to highest value)

Create a two-column table

In the first column enter a data value.

In the second column enter the frequency of a data item

Count how many times one particular data value appears in the set (how many repetitions). If it appears only once, its frequency is 1; twice, frequency 2, etc.

For each single (different) data value complete the frequency column.

**Grouped**

For grouped data representations you create classes: A class is just an interval of values, for example between [125, 130[

For each class interval you create, count how many data values fall within the interval. For the class given as example it will encompass all values between 125 and 129, It I counted correctly its frequency is 4.

Complete the frequency table for the class.

**How many classes should you create? **Usually this information is given to you. If not, create a moderate number of classes (4,5) It depends on the span of the distribution (highest value- lowest value). The intervals should have equal length. Read your instructions.

First sort the data in ascending order (from lowest to highest value)

Create a two-column table

In the first column enter a data value.

In the second column enter the frequency of a data item

Count how many times one particular data value appears in the set (how many repetitions). If it appears only once, its frequency is 1; twice, frequency 2, etc.

For each single (different) data value complete the frequency column.

For grouped data representations you create classes: A class is just an interval of values, for example between [125, 130[

For each class interval you create, count how many data values fall within the interval. For the class given as example it will encompass all values between 125 and 129, It I counted correctly its frequency is 4.

Complete the frequency table for the class.

Sep 02, 2012 | Office Equipment & Supplies

Here you go.

- Press the [Reports] button on the Control Panel

- Press the [Up] or [Down] arrow until 'Systems Data' is displayed on the Display Screen.
- Press the [Enter] button.

The System Data list will be printed with the following information:**Total Page Counts:**Total number of pages printed**CRU Prints:**Number of pages printed using the current Toner (Dry Ink) Cartridge**Replaced Toner Counts:**Number of new Toner Cartridges installed in the machine**Replaced Drum Counts:**Number of new Drum Cartridges installed in the machine**Current Drum Page Counts:**Number of pages printed using the current Drum Cartridge**Platen Scan Page Counts:**Number of pages scanned using the Document Glass**ADF Scan Page Counts:**Number of pages scanned using the Automatic Document Feeder (ADF)

Feb 10, 2010 | Xerox WorkCentre M15i Laser Printer

My suggestion is to use a Pivot Table. Follow these instructions:

Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.

Click NEXT on step 1 of pivot table wizard.

For step two you will want to highlight all of the data on your sheet. then click next.

Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.

Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet. Next drop another instance of the STATUS field into the "drop row fields here" column. And lastly drop the OWNER field into the "drop column fields here" section. You should now be viewing a report showing you exactly what you were looking for.

Regards,

Joe

Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.

Click NEXT on step 1 of pivot table wizard.

For step two you will want to highlight all of the data on your sheet. then click next.

Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.

Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet. Next drop another instance of the STATUS field into the "drop row fields here" column. And lastly drop the OWNER field into the "drop column fields here" section. You should now be viewing a report showing you exactly what you were looking for.

Regards,

Joe

May 07, 2009 | Microsoft Excel for PC

Use 3 pivot tables, put a, b, and c in the row areas and "Count of a", "Count of b" and "Count of c" in the data sections. That will give you a count of each date for each column

Apr 28, 2009 | Microsoft Computers & Internet

Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Jan 17, 2009 | Microsoft Excel for PC

{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

Hi,

Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.

Thanks

Proton

Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.

Thanks

Proton

Oct 17, 2008 | Microsoft Excel for PC

It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Computers & Internet

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

53 people viewed this question

Usually answered in minutes!

Noted...with thanks:)

I'll have to look this one up at work tomorrow.

I'll have to look this one up at work tomorrow.

×