Find the Regression Line Using Excel for Mr. William Profit

Mr. William Profit is studying companies going public for the first time. He is particularly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information.

Company Size ($ millions), X Price per Share, Y Company Size ($ millions), X Price per Share Y

Determine the coefficient of determination. Do you think Mr. Profit should be satisfied with using the size of the offering as the independent variable?

Solution Summary

Mr. William Profit is studying companies going public for the first time. He is particularly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information.

Findthe equation of theregressionlineforthe given data. Then construct a scatter plot of the data and draw theregressionline. (The pair of variables have a significant correlation.) Then use theregression equation to predict the value of y for each of the given x-values, if meaningful. The table below shows the heigh

Can you help me create a scatterplot, with an inserted trend line, showing theregression equation usingthe data below?
A sample of 12 homes sold last week in St Paul, Minnesota, is selected. The results are shown below.
Home Size (1000s sq feet) Home Price ($1000)
1.4 100
1.3 110
1.2 105
1.1 120
1.4 80
1 105
1.3

Findthe equation of theregressionlineforthe given data. Predict the value of Y when X=-2? Predict the value of Y when X = 4?
x -5 -3 4 1 -1 -2 0 2 3 -4
y =10 =8 9 1 =2 =6 =1 3 6 =8
Show all work.

You are interested in finding out if a student's ACT score is a good predictor of their final college grade point average (GPA). You have obtained the following data and are going to conduct a regression analysis. What is the best fit to conduct this analysis?
ACT | GPA
22.0 | 3.0
32.0 | 3.78
33.0 | 3.68
21.0 | 2.94
27

11. A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected:
Speed MPG
44 22
51 26
48 21
60 28
66 33
61 32
a. Plot these data in a scatter diagram.
b. Compute the coefficient of correlation.
c.

Mr.WilliamProfit is studying companies going public forthe first time. He is particularly interested in the relationship between the size of the offering and the price per share. A sample of 15 companies that recently went public revealed the following information.
Company Size ($ millions), X Price per Share, Y Company Si

A company has observed that there is a linear relationship between indirect labor expense (ILE) , in dollars, and direct labor hours (DLH). Data for direct labor hours and indirect labor expense for 18 months are given in the file ILE_and_DLH.xlsx
Treating ILE as the response variable, use regression to fit a straight line t

X: 1 3 10 16 26 36
y: 42 50 75 100 150 200
{ex=92, Ex=617, Ex^2=2338, Ey^2=82,389, EXY=13,642, and r=0.860}
a) Draw scattered diagram and verify ey, ex^2, ey, ey^2, exy and the sample coefficient r
b) Find sample means for x, y, and find a, and b and the equation of least squar