Using MS Excel and the data below, you need to Find the linear regression model (i e , the equation) If a student is spending 8 hours of study per week, and his her focus level is 3 out of 5, using the regression model, predict his her GPA Student Hours of study per No week Focus level (1 5) Student GPA 1 20 5 4 2 25 4 3 9 3 10 2 2 21 4 10 2 2 3 5 15 3 3 6 16 4 2 9 7 14 3 2 7 8 15 4 2 9 22 4 3 6 10 18 4 3 5 11 12 2 3 12 10 1 1 9 13 7 2 1 8 14 14 3 2 88 15 30 4 3 8 16 19 3 4

The Answer is in the image, click to view ...

Question: Using MS-Excel and the data below, you need to: Find the linear regression model (i.e., the equation) If a student is spending 8 hours of

Using MS-Excel and the data below, you need to: Find the

Using MS-Excel and the data below, you need to:

Find the linear regression model (i.e., the equation)
If a student is spending 8 hours of study per week, and his/her focus level is 3 out of 5, using the regression model, predict his/her GPA.

Student | Hours of study per No. week Focus level (1-5) Student GPA 1 20 5 4. 2 25 4 3.9 3 10 2 2.21 4 10 2 2.3 5 15 3 3 6 16 4 2.9 7 14 3 2.7 8 15 4 2 9 22 4 3.6 10 18 4 3.5 11 12 2 3 12 10 1 1.9 13 7 2 1.8 14 14 3 2.88 15 30 4 3.8 16 19 3 4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A marketing professor at Givens College is Interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last...

1.A restaurant chain collected data on total fat (denoted by fat) in grams and the protein content in grams for various items on their menu. Some summary statistics of this data are shown below:...

MPE781 T3 2019Exam Question Bank (Question answers will not be given and discussed by instructors) Section A: A.1. a. Define the price elasticity of demand. b. Suppose that government would like to...

Unit 3 Problem Set NAME: Elements of Statistics--FHSU Virtual College--Summer 2015 REMEMBER, these are assessed preparatory problems related to the content of Unit 3. The Unit 3 Exam will consist of...

\f\f1) Using the SILVERSPRING data set, develop a multiple linear regression model to predict asking price based on assessed value, size and number of bedrooms. a) Interpret the meaning of the slope...

16. The correlation coefficient between per capita income in thousands of dollars and the number of medical doctors per 10, 000 residents is r=0.934. (a) Find the coefficient of determination. (b)...

the data is given by this Exel. For 1E, the submission day is 3rd of May. Question 1. Forecasting (20 marks) The forecasting techniques introduced in lectures can be used to forecast not only demands...

Final Exam MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. Solve the problem. 1) The average age of the students in a statistics class is 22...

A capacitor's plates hold 1.3 C when charged to 60 V. What's its capacitance?

Discuss the potential for Samoa Ltd being classified as a subsidiary of Russia Ltd.

simple capital structure might include: 8 0 1 2 0 - 5 4 Multiple ChoiceStock rights.Convertible bonds.Nonconvertible preferred stock.Stock purchase warrants.

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...