The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 356 Weeks Ago |
| Questions Answered: | 20103 |
| Tutorials Posted: | 20155 |
MBA, PHD
Phoniex
Jul-2007 - Jun-2012
Corportae Manager
ChevronTexaco Corporation
Feb-2009 - Nov-2016
Question description
statistics concepts and descriptive measures, 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 change to warm up on evaluating some basic descriptive statistics using excel prior to the course start.
Choose of the following datasets to complete this assignment:
Consumer Food, Financial, Hospital
Answer each of the following in a total of 90 words or less:
1) For each column, identify whether the data is qualitative or quantitative
2) Identify the level of measurement for the data in each column
3) 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 Excel=MAX function and find the minimum value using the Excel's = MIN function
Note: pay special attention to your reporting, even of an excel sheet. Treat it as a report you are submitting to a coleague or supervisor who is infinitely ignorant and infinitly intelligent. Pick and choose the relevant parts. Include only what is relevant, in a crystal clear fashion.
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l