Discuss the folloiwng:
Q1: A recent national survey reports that the general population gives the president an average rating of µ = 62 on a scale of 1 to 100. A researcher suspects that college students are likely to be more critical of the president than people in the general population. To test these suspicions, a random sample of college students is selected and asked to rate the president. The data for this sample are as follows: 44, 52, 24, 45, 39, 57, 20, 38, 78, 74, 61, 56, 49, 66, 53, 49, 47, 88, 38, 51, 65, 47, 35, 59, 23, 41, 50, 19.
You are to calculate standard deviation in written form using the table Once you are done with your calculations. Your written work for your standard deviation should match or come close to your Microsoft Excel output. Once you are done calculating descriptive statistics, perform a hypothesis test
a. Using the data listed, calculate by hand the standard deviation.
b. Using Microsoft Excel, type 'Ratings' in column A, cell 1. Below cell one, start typing your data in the A column.
c. Hypothesis Testing: Now that you have calculated your descriptive statistics to the data above, you will be able to use your results and perform a hypothesis test. In your results: state an appropriate null hypothesis, indicate the level of significance, identify the critical value, calculate the test statistic, evaluate the test statistic in light of the critical value, and make a decision about the null hypothesis.
Q: President Ratings
Written work: Calculate standard deviation
Scores/Values Deviations Mean (average)Deviation Variance Squared Deviations Standard Deviation
N =(X) (X - Mean)
Attachment:- Calculate the sd.rar