Description
Complete both problems that are attached and fill in the questions in the excel sheet attached, as well as creating excel sheets with charts. MAke sure to complete histogram in Excel. MUST ATTACH THE EXCEL DOC, NOT SCREENSHOT
Also need this filled in :
# 1 Complete Problem 2 in your course text on page 177 | Your Answer |
a. mean/average | |
b. sample standard deviation | |
c. median | |
d. Is the median equal to the mean? Why or why not? | |
# 2 Complete Problem 5 in your course text on page 178 | |
a. mean for ECU pitchers | |
b. standard deviation for ECU pitchers | |
c. copy your histogram below |
Please copy ECU Pitcher Histogram (2c) below
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Please find attached the complete work.In case of any doubt kindly reply ..Pallvee
Q-2
x
1285
2100
2465
3541
3846
4581
5000
6524
7845
8524
9845
a)
Simple mean
Average(B2:B12)
5050.545
b)
Standard
Deviation
c)
Median
d)
Median is not equal to mode.
STDEV(B2:B12)
2802.758
MEDIAN(B2:B12)
4581
This is because the data is not equally distributed and is not
representatibve of any case
Q-5
For finding mean of the dataset, we use the excel statistical function AVERAGE
AVERAGE(A...