Statistics Concepts and Descriptive Measures

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

Click the Assignment Files tab to submit your assignment.

You can leave a response, or trackback from your own site.


9 Responses to “Statistics Concepts and Descriptive Measures”

  1. 453391 474218Yay google is my world beater assisted me to discover this wonderful internet web site ! . 831461

  2. CI CD says:

    593296 807080I gotta bookmark this site it seems very beneficial . 630447

  3. Devops says:

    215509 680251Excellent job on this article! I truly like how you presented your facts and how you produced it fascinating and effortless to realize. Thank you. 780765

  4. 428587 860264We are a group of volunteers and opening a new system in our community. Your internet website given us with valuable data to work on. Youve done an impressive job and our entire community is going to be grateful to you. 767390

  5. 558610 5870471 can undertake all sorts of advised excursions with assorted limousine functions. Various offer great courses and a lot of can take clients for just about any ride your bike over the investment banking location, or even for a vacation to new york. ??????? 868496

  6. 23826 14934Exceptional weblog here! Also your website loads up fast! What host are you making use of? Can I get your affiliate link to your host? I wish my web site loaded up as rapidly as yours lol 233894

  7. 539736 368859I conceive this web site has got some real excellent details for everyone : D. 877644

  8. 755174 917989I see something genuinely special in this web site . 653198

  9. 281681 759230Interesting blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog shine. Please let me know where you got your theme. Many thanks 918539

Leave a Reply

Powered by WordPress | Designed by: buy backlinks | Thanks to webdesign berlin, House Plans and voucher codes