Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the MS Excel file to answer the questions. create tables and graphs in MS Excel and add the comments to the tables and graphs.
Use the MS Excel fileto answer the questions.
create tables and graphs in MS Excel and add the comments to the tables and graphs.
1. Evaluate normality of the distribution of GPA in this data set.
2. Build the 90% confidence interval for population mean age of students. Show your work.
3. Build the 95% confidence interval for population mean GPA. Show your work.
T V W X Y Z AA 0 P Q R S U E F G H I J K L M N A B C D 1 GPA Country 3.5 Canada 25 2.43 USA 22 3.19 USA VOU AWN 24 2.55 Korea 32 1.21 China 19 3.1 USA 19 3.12 Korea 23 2.96 USA 10 24 3.05 Canada 11 22 2.63 India 12 21 2.92 Korea 13 20 3.21 USA 14 23 2.78 Canada 15 17 3.72 Japan 16 22 2.76 Canada 22 3.29 India 18 20 2.94 USA 19 27 2.58 Canada 20 31 1.86 India 21 31 1.64 Canada 22 27 2.25 Canada 23 24 2.76 Vietnam 24 19 3.21 Canada 25 29 2.04 India 19 3.68 Canada 22 2.67 Canada 28 28 2.02 Canada 29 22 2.74 Canada 30 22 2.95 Korea 31 19 3.87 Canada 32 26 2.6 Korea 33 16 3.62 Canada 34 19 3.41 India 35 27 2.43 Canada 36 23 2.48 Canada 37 24 2.61 Japan - + 100% Sheet1 + Ready 4 W XStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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