Below are monthly rents paid by 30 students who live off campus. 590 590 590 790 560 450 550 890 600 480 580 520 420 600 510 520
710 775 460 480 620 550 570 365 590 660 680 700 580 630 Click here for the Excel Data File (a) Using Excel, find the mean, median, mode, and standard deviation. (Round your answers to 2 decimal places.) Descriptive Statistics Data Mean 587 Median 585 Mode 590 Standard Deviation 112.54 (b) Which measure or measures of central tendency are most appropriate for this data set
1 answer:
Answer:
(a) Mean = 587
Median = 585
Mode = 590
Standard deviation = 112.54
(b) Mean and median are both appropriate as they are close in value, suggesting that the data is quite symmetric.
Explanation:
All four measures are calculated by inserting simple formulas in Excel. These are shown in the below screenshot of the work file.
You might be interested in
Okay so first we need to find how many days are in March and February. March has 31 days and because this year was a leap year February has 29 days.
The next step is to convert days to hours.
March: 31x24=744
February: 29x24=696
Now its time to graph
The next step is to convert days to hours.
March: 31x24=744
February: 29x24=696
Now its time to graph
I hope this helps you
