The data below show the price, in pence per kg, charged by a market-stall holder for apples, and the quantity, in kg, sold in a day when she charges these prices.

Price/p per kg 75 85 100 115 130 150
Quantity sold/kg 50 47 43 40 35 30

Perform linear regression on these, data taking the price as the independent variable and the quantity sold as the dependent variable, and then choose three FALSE statements.

Options.

A. Linear regression gives poor fit to data

B. The regression coefficient is -0.9987 correct to four decimal places.

C. It would not to be wise to extrapolate the quantity of apples she would sell at a price of £1.80 per kg from these data

D. The regression equation is y= -0.2646x+69.72 giving the coefficients to four significant figures.

E. The regression equation is y= 69.72x-0.2646 giving the coefficients to four significant figures.

F. The slop of the regression line indicates that for every penny increase in price, she reduces her sales by about 0.26kg a day.

G.The variable x in the regression equation represents the quantity of apples sold in a day

H. The variable x in the regression equation represents the price charged for apples.

Solution Preview

The calculations are shown in the excel file attached.

Simple LinearRegression and Multiple Regression.
I'd like to ask whether you think multiple regression (the use of more IV's) is always better than simple regression? Why or why not?
What problems may exist with multiple regression that are not an issue for simple linearregression?

Develop simple linearregression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually. Do the assumptions of linearregression hold for your models? How do these models compare to the multiple regression models?

I used the formula Y =a+bX but
1.Regarding the causal method of linearregression:
a.What is the appropriate linearregression model (equation) to forecast sales?
Use Excel and the LINEST function to create it.
b.Use the equation to generate your forecasts for months 16-19. NOTE: There is NO missing information.

The annual salary of an electrical engineer is given in terms of the years of experience by the table below. Find the equation of linearregression for the above data and obtain the expected salary for an engineer with 45 years of experience. Round to the nearest $100.
x y
2 53.5
5 56.3
9 59.8
14 6

This problem has to be done in Excel.
Prepare a forecast, using simple linearregression, for each quarter of the next year from the following past 2 years' quarterly sales information.
Quarter Sales
1----- 160
2----- 195
3----- 150
4----- 140
5----- 215
6----- 240
7----- 205
8----- 190

I'm working on linearregression and I'm stuck on the equation because I'm coming up with a negative number which I don't think is an accurate forecast. The problem also asks for error tests, which I think I have the correct formulas for and will work once the first part is done. Please help! Full details and questions attached

If my dependent variable (Y) is wages
If my independent variable (X) is a 2-yr. degree versus a 4-yr. degree
Can you help me with a linearregression analysis if I have wages representing a 2 and 4 year degree?
Those wages being: 2 yr. degree, $11,702, $24,509, $35,185, $34,746
Wages for a 4 yr. degree, $29,997, $33,959, $22