Problem 1- Use the datafrom file named “EA1.2 Class Data Gender”
For each of the variables – Gender, Miles from College to Home States, and Capitols You Can Name calculate the following statisticsand graphs:
a. Using at most seven classes, organize the sample data into a frequency distribution.
b. Graph out the data for gender in a pie chartand the miles and capitols in a bar chartor histogram.
c. Calculate the meanfor each of the 3 variables, use the actual raw data.
d. Calculate the medianfor each of the 3 variables, use the actual raw data.
e. Calculate the modefor each of the 3 variables, use the actual raw data.
f. Calculate the rangefor each of the 3 variables, use the actual raw data.
g. Calculate the sample standard deviationfor each of the 3 variables, use the actual raw data.
Problem 2 – Refer to the following diagram.
a. What is the graph called?
b. What are the median, and first and third quartile values?
c. Is the distribution positively skewed? Tell how you know.
d. Are there any outliers? If yes, estimate these values.
e. Can you determine the number of observations in the study?
Problem 3 – Use the data from the file named “EA1.2 Class Data Gender”
a. Using the scatter plotfeature in Excel, graph out Miles versus States Named.
b. Run the regression analysisto determine if the is a relationship between Miles and States, is Miles a good predictor of the number of States and Capitals that a student can name? Is this a significant regression equation?
c. What is your prediction for the number of States and Capitals that can be named given that I told you that the student lived just 10 miles from College?
Problem 4 – The following data shows the retail price for 12 randomly selected laptop computers along with their corresponding processor speeds.
Computers Speed Price
1 2.0 $2,689
2 1.6 1,229
3 1.6 1,419
4 1.8 2,589
5 2.0 2,849
6 1.2 1,349
7 2.0 2,929
8 1.6 1,849
9 2.0 2,819
10 1.6 2,669
11 1.0 1,249
12 1.4 1,159
a. Develop a linear equation that can be used to describe how the price depends on the processor speed.
b. Based on your regression equation, is there one machine that seems particularly over- or underpriced?
c. Compute the correlationcoefficient between the two variables. At the .05 significance level conduct a test of hypothesis to determine if the population correlation could be greater than zero.
Problem 5 – A wireless phone service charges $14.99 as a monthly charge and $0.30 per minute for local calls.
a. How much would you pay in a month when you made ten local calls of three minutes each?
b. Let C represent your total monthly cost; assuming you made only local calls, did not receive any calls, and the total number of minutes you were on the phone is m, write the equation to find your monthly bill.
c. How can you tell that the relationship between C and m follows a linear pattern?
d. Graph the function that gives the total monthly cost and give the slope of the line.
See attached documents.
The solution provides step by step method for the calculation of Descriptive statistics, correlation testing and Regression equation. Formula for the calculation and Interpretations of the results are also included.