Question: 1. Using the following table of relation between X & Y (Y is the independent Variable): Xi 0 2 4 3 6 7 8 9

1. Using the following table of relation between X & Y (Y is the independent Variable): Xi 0 2 4 3 6 7 8 9 Vi 5 8 2 3 20 30 a. Find the estimated regression equation. Show ALL your calculations and the appropriate formula. WRITE Formula in all the questions below and substitute for the numbers, demonstrate your work. b. Calculate R2. Comment on the Goodness of the Fit. Is it a good fit? Why? C. Test the hypothesis regarding the significance of the slope Bi. (Use a = 0.05) Show ALL the calculations necessary to get your answer. d. Calculate the values of F, using formula for F statistics. e. Draw the scatter diagram and also your estimated regression line. Part B): Perform the Simple Regression in Excel and Submit the Summary Output along with your response

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 Mathematics Questions!

Show all work, no excel 1. Using the following table of relation between X&Y(Y is the independent Variable): a. Find the estimated regression equation. Show ALL your calculations and the appropriate...

hello! i am struggling to fill some of these out! hope you can help :) Vinson Co. Manufactures and sells one product. Assume the selling price for each item is $225/per unit. The following...

only " in java " they advised us to use the software jGRASP they ask to review a sample program they sent to us before starting this project. I put the sample program at the end that' s the only...

Instructions: " in java " Review the sample program before starting this project. put the sample program at the end Playing a video game on a computer can give different experiences based on the...

Do it correctly Problem set 3 - The Specific Factors Model Exercise 1 Consider the following table with outputs of x and y: x 4 3 2 1 |0 0 7 12 15 16 a) Plot the production possibilities frontier...

This project has three parts. Remember to make a copy of this project so you can refer to it when completing the other phases. Review the sample program before starting this project. The program link...

Playing a video game on a computer can give different experiences based on the performance capabilities of the computers hardware (typically processor and graphics card among other things)....

You want to rent a three-bedroom apartment close to campus with two of your friends. You have checked the sizes and the rents of a bedroom in five of those apartments. The data are summarized in the...

Refer to Chapter 9, Review Exercise 18. In the study cited in that exercise, Maria Mathias (A-13) investigated the relationship between ages (AGE) of boys and improvement in measures of...

The figures below depict three different wave functions of a particle confined to a one dimensional box -1xl A 1 0.5 ok -0.5 -1 -1 -0.5 0 0.5 1 x 1.25 1 0.75 0.5 0.25 0 -0.25 -0.5 -1 -0.5 B 0 0.5 x 1...

Case study requirements: Students have to know which Performance Measurement System is used in their case study and justify the perspectives that the PMS was built on it and the rest information of...

Taxes on Roth retirement accounts are paid during the year of contribution rather than the year of withdrawal on the account. True False

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...