Question
A) * Investigate the descriptive statistics of the Reading score using Data Analysis ToolPak (1pt) **Then, find ranges of the true mean values of Reading
A)
* Investigate the descriptive statistics of the "Reading" score using Data Analysis ToolPak (1pt)
**Then, find ranges of the true mean values of "Reading" score based on 68%, 95%, and 99% certainty using the descriptive statistics results (2pts).
B) Calculate the average of "Writing", "Math", and "Science" scores based on "Program" using PivotTable (2pts)
Hint: Place "Program" on the row level and Averages on the column level.
C)
* Calculate the correlations coefficients between Math, Science, and Social Studies (1.5 Pts).
** Interpret the correlation analysis results. (1.5 pts)
D) Investigate if there are any outliers in "social studies" scores based on the z-Scores (2pts).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started