I have a textbook instruction for excel as follows 'click 'tools', 'data analysis'....and 'histogram'. click 'ok'. Well, I went into tools, and allas, there is no 'data analysis'. Am I missing something here?
2006-07-25 17:16:58 · 6 answers · asked by Anonymous in Computers & Internet ➔ Software
It's for a more recent version of Excel than you and I are using. I have to make a Histogram manually in Excel 97 or 2000.
Click on "help" then "contents/index" and search the index for "histograms". It should explain how to create them in whichever version you're using.
2006-07-25 17:23:31 · answer #1 · answered by yellow_jellybeans_rock 6 · 0⤊ 0⤋
No, you aren't. It is probably an "Add-In."
The easier way to make a Pareto chart is to sort the data, highest to lowest, and then just do a bar chart. It's not a true Pareto, because you won't have the cumulative percent contribution line chart included, but it will give the simple Pareto. I don't think the Excel Pareto gives you the cumulative percent contribution anyway. You may need statistical software to do that. Excel sucks for stats!
2006-07-25 17:26:45 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Not enough information. What version Excel? What are you trying to do? Suggest you open your worksheet, enter your data, then check the Tools options. If the option you want isn't there, why not checkout Help on the toolbar?
2006-07-25 17:23:35 · answer #3 · answered by TheHumbleOne 7 · 0⤊ 0⤋
Summary functions for data analysis
Summary functions are used in automatic subtotals, data consolidations, and PivotTable and PivotChart reports. In PivotTable and PivotChart reports, the following summary functions are available for those that are based on non-OLAP source data. For reports that are based on OLAP data, the available summary functions depend on how the cube was defined on the server. For information about summary fields available for your source data, contact your OLAP database administrator.
Function Summarizes
Sum The sum of the values. This is the default function for numeric source data.
Count The number of items. The Count summary function works the same as the COUNTA worksheet function. Count is the default function for source data other than numbers.
Average The average of the values.
Max The largest value.
Min The smallest value.
Product The product of the values.
Count Nums The number of rows that contain numeric data. The Count Nums summary function works the same as the COUNT worksheet function.
StdDev An estimate of the standard deviation of a population, where the sample is all of the data to be summarized.
StdDevp The standard deviation of a population, where the population is all of the data to be summarized.
Var An estimate of the variance of a population, where the sample is all of the data to be summarized.
Varp The variance of a population, where the population is all of the data to be summarized.
Found this in Excel "help". I couldn't find it either on my toolbar.
Hope this helps.
2006-07-25 17:24:47 · answer #4 · answered by phy333 6 · 0⤊ 0⤋
Data Analysis Tools are a special add-in that is not installed by default with MS Excel. Click on Tools-->Add-Ins-->and check "Analysis Toolpak - VBA". You will need your MS Office CD to load this.
2006-07-25 17:24:53 · answer #5 · answered by snare3011 3 · 0⤊ 0⤋
reverse phone number search compiles hundreds of millions of phone book records to help locate the owner's name, location, time zone, email and other public information.
Use a reverse phone lookup to:
Get the identity of an unknown caller.
Identify an area code.
Recall the name of a person whose number you wrote down.
Identify an unfamiliar phone number that shows up on your bill.
https://tr.im/721a7
2015-01-24 09:03:30 · answer #6 · answered by Anonymous · 0⤊ 0⤋