Statistics Quantitative Analysis Questions

User Generated

vgforggregunaeriratr

Mathematics

ecu

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

2. You are given the following data set: 5000,6524, 8524,7845, 2100,9845, 1285,3541, 4581, 2465,3846. Using Excel's statistical functions, complete the following: a. Calculate the simple mean. b. Calculate the standard deviation. c. Calculate the median. d. Is the median equal to the mean? Why or why not? 5. The following data were collected from the ECU baseball team regarding their pitcher's earned run averages (ERA) for the last 2 years. Using Excel's statistical functions, complete the following questions. 2.59 3.58 6.25 2.41 2.22 5.55 5.21 3.98 ERA 3.97 2.85 8.00 5.41 5.98 4.25 3.68 6.54 4.68 2.33 a. What is the mean of the data set for the ECU pitcher's ERA? b. What is the standard deviation of the data set for the ECU pitcher's ERA? c. Construct a histogram for the ECU pitcher's ERA data set, using 0.5 as your class width and starting with 2.0 as your lowest class.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags