Question: Spreadsheets have procedures for automatically describing data, such as the 'Data Analysis' tool in Excel (if this is missing you have to load the Analysis

Spreadsheets have procedures for automatically describing data, such as the 'Data Analysis' tool in Excel (if this is missing you have to load the Analysis ToolPac as an add-in). An option in this is 'Descriptive Statistics' which automatically finds 13 measures for a set of data (illustrated in Figure). Explore the analyses done by theseprocedures.
Spreadsheets have procedures for automatically describing data,

4 1 Data description Data description Data 45 35 3 Mean tandard error Median Mode Standard deviation Sample variance Kurtosis Skewness Range Minimum Maximum Sum Count 45.41 3.92 45.00 45.00 16.15 260.76 -0.75 -0.21 53.00 19.00 72.00 772 17 21 34 45 10 12 13 72 54 15 20 17 51 39 18 2057

Step by Step Solution

3.40 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Microsoft Excel is the most widelyused spreadsheet but there are many alternatives of vari... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

180-M-S-Q-M (243).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!