Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

in Excel, In the first tab,Generate random numbers for 40 students for their age between 23 to 35 , Performance % between 40 to 100

in Excel,

In the first tab,Generate random numbers for 40 students for their age between 23 to 35 , Performance % between 40 to 100 and Weekly study hours between 2hrs to 14 hrs
3. Calculate mean for all variables
4. Calculate standard deviation for all variables
5. What is the confidence interval for population mean each variables ( level of confidence 95%)
6. Calculate coefficient of correlation, determination and regression equation for students' age and performances
7. Calculate coefficient of correlation, determination and regression equation for students' study hours and performances
8. Explain your findings

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential Calculus Early Transcendental Functions

Authors: Ron Larson, Robert P. Hostetler, Bruce H. Edwards

1st Edition

618879188, 618879182, 978-0618879182

More Books

Students also viewed these Mathematics questions

Question

Distinguish between the DBMS and a file management system.

Answered: 1 week ago

Question

=+Based on this, what model might you use to predict Log10Price?

Answered: 1 week ago