Computer Project for Student Exam Scores
The data in the excel spread sheet titled Data for Hypothesis Testing in the column titled Scores from Student Population represents more than a thousand math exam scores (the entire population of test takers.) The column titled Sample Forced to 3 hrs Nightly Study Halls represents a group of students that were forced to attend math study halls for one semester and then they were retested. The column titled Sample Hypnotized to Perform Better represents students that were hypnotized and conditioned to use their spare time to study math and then retested.
Prepare a report in word, with title page, which includes graphs and calculations when appropriate to address all of the questions that are outlined below.
1. Evaluate the Scores fromStudent Population,Forced to 3 hrs Nightly Study Halls, and Sample Hypnotized to Perform Better for OUTLIERS. The exam was on a scale of 0-100% with a 20 point bonus.
a. Arrange the data in order and find Q1 and Q3
b. Find the interquartile range: IQR=Q3-Q1
c. Eliminate any data that is smaller than Q1-1.5(IQR)
or larger than Q3+1.5(IQR). The data remaining after screening will be used for the remaining analysis.
How many outliers were in the Scores from Student Population data set?
How many outliers were in the Forced to 3 hrs Nightly Study Halls data set?
How many outliers were in the Sample Hypnotized to Perform Better data set?
2. Determine if all three Columns of Data are normal.
a. Report the Pearson's index PI of skewness for Scores from Population and explain the acceptable range.
b. Report the Pearson's index PI of skewness for Sample Forced to 3 hrs Nightly Study Hallsand explain the acceptable range.
c. Report the Pearson's index PI of skewness for Sample Hypnotized to Performand explain the acceptable range.
d. Plot a Histogram of Scores from Population and refer to its normality.
e. Plot a Histogram of Sample Forced to 3 hrs Nightly Study Halls refer to its normality.
f. Plot a Histogram of Sample Hypnotized to Perform refer to its normality.
3. Confidence intervals z scores.
a. Calculate a 95% confidence interval from the population mean. Using the Sample Forced to 3 hrs Nightly Study Halls data. Does the mean of the Sample Forced to 3 hrs Nightly Study Halls data fall within the confidence interval of the mean of the Scores from the Population.
b. Calculate a 95% confidence interval from the population mean. Using the Sample Hypnotized to Perform Better data. Does the mean of the Sample Hypnotized to Perform Better data data fall within the confidence interval of the mean of the Scores from the Population.
4. Confidence intervals t scores.
a. Calculate a 95% confidence interval from the Sample Forced to 3 hrs Nightly Study Halls mean. Does the mean of the population data fall within the confidence interval of the mean of the Sample Forced to 3 hrs Nightly Study Halls.
b. Calculate a 95% confidence interval from the Sample Hypnotized to Perform Better data. Does the mean of the Population data fall within the confidence interval of the mean of the Sample Hypnotized to Perform Better.
5. Hypothesis Testing.
a. Write a null hypothesis and alternate hypothesis that would go along with the data (Sample Forced to 3 hrs Nightly Study Halls) that was collected.
b. Write a null hypothesis and alternate hypothesis that would go along with the data (Sample Hypnotized to Perform Better) that was collected.
c. Using a level of significance of α=.05 for these Two-Tailed hypothesis, make conclusions about which hypotheses to accept and which to reject using z scores.
6. Hypothesis Testing.
a. Write a null hypothesis and alternate hypothesis that would go along with the data (Sample Forced to 3 hrs Nightly Study Halls) that was collected.
b. Write a null hypothesis and alternate hypothesis that would go along with the data (Sample Hypnotized to Perform Better) that was collected.
c. Using a level of significance of α=.05 for these Two-Tailed hypothesis, make conclusions about which hypotheses to accept and which to reject using t scores.