**Influence of Economics on Household Decision**

$ 12.00

Purpose of Assignment | ||||

The purpose of this assignment to orient students to the key concepts in statistics. This assignment will introduce students to the language of statistics. Students will also get a chance to warm-up on evaluating some basic descriptive statistics using Excel^{®} prior to the course start. |
||||

Assignment Steps | ||||

This assignment has an Excel^{®} dataset spreadsheet attached. You will be required to only do one of the three datasets. |
||||

Resource: Microsoft Excel^{®}, Statistics Concepts and Descriptive Measures Data Set |
||||

Download the Statistics Concepts and Descriptive Measures Data Set. | ||||

Choose one of the following datasets to complete this assignment: | ||||

Consumer Food | ||||

Financial | ||||

Hospital | ||||

Answer each of the following in a total of 90 words: | ||||

For each column, identify whether the data is qualitative or quantitative. | ||||

Identify the level of measurement for the data in each column. | ||||

For each column containing quantitative data: | ||||

Evaluate the mean and median | ||||

Interpret the mean and median in plain non-technical terms | ||||

Use the Excel =AVERAGE function to find the mean | ||||

Use the Excel =MEDIAN function to find the median | ||||

For each column containing quantitative data: | ||||

Evaluate the standard deviation and range | ||||

Interpret the standard deviation and range in plain non-technical terms | ||||

Use the Excel =STDEV.S function to find the standard deviation | ||||

For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel's =MIN function | ||||

Grading Guide | ||||

Content | Met | Partially Met | Not Met | Comments: |

This assignment has an Excel® dataset spreadsheet attached. Students will be required to do one of the three datasets only and submit. | ||||

Download the Consumer Food, Financial, or Hospital Excel® Data Set. | ||||

Note: you have to work on only ONE dataset and not ALL. | ||||

Answer each of the following in a total 90 words: | ||||

· For each column, identify whether the data is qualitative or quantitative. | ||||

· Identify the level of measurement for the data in each column. | ||||

· For each column containing quantitative data: | ||||

o Evaluate the mean and median | ||||

o Interpret the mean and median in plain non-technical terms | ||||

o Use the Excel =AVERAGE function to find the mean | ||||

o Use the Excel =MEDIAN function to find the median | ||||

· For each column containing quantitative data: | ||||

o Evaluate the standard deviation and range | ||||

o Interpret the standard deviation and range in plain non-technical terms | ||||

o Use the Excel =STDEV.S function to find the standard deviation | ||||

For range (maximum value minus the minimum value), find the maximum value using the Excel =MAX function and find the minimum value using the Excel’s =MIN function | ||||

Total Available | Total Earned | |||

3 | #/3 | |||

Writing Guidelines | Met | Partially Met | Not Met | Comments: |

The paper—including tables and graphs, headings, title page, and reference page—is consistent with APA formatting guidelines and meets course-level requirements. | ||||

Intellectual property is recognized with in-text citations and a reference page. | ||||

Paragraph and sentence transitions are present, logical, and maintain the flow throughout the paper. | ||||

Sentences are complete, clear, and concise. | ||||

Rules of grammar and usage are followed including spelling and punctuation. | ||||

Total Available | Total Earned | |||

2 | #/2 |

**Category:**Business, General Business

**Good_Morning**

- Ratings 2
- Grade:
**A+** - Questions 1
- Solutions 3084
- Blog 0
- Earned: $496.30