Regression

[2suchy7]

The sale of article X is measured on a weekly basis, The company uses various sales promoting parameters such as radio, web, store, and shop commercials etc. In the following these parameters are Called A, B, and C. The sale and parameter costs per week are shown in addendum 1.

Addendum 2 shows a number of regression analyses that all explain the sale by the parameters A, B and C - individually or combined.

1) Coment on the regression analyses set up in addendum 2 and estimate which of the models explains the sale of article x best.

In the following the management of XYZ decides to use parameter A solely to explain the sale of commodity X. See addenda 2c and 2f.

2) Set up a model showing sale as a function of parameter A. Determine and comment on the coefficients of the model.

3) Examine and comment on whether the assumptions of the model are met.

4) Assume that the costs for parameter A is 101. Calculate a 95% prediction interlval for the sale of the week in question.
Addendum 1 - http://img594.imageshack.us/i/add1n.jpg/
Addendum 2a - http://img30.imageshack.us/i/add2a.jpg/
Addendum 2b - http://img340.imageshack.us/i/add2b.jpg/
Addendum 2c - http://img163.imageshack.us/i/add2c.jpg/
Addendum 2d - http://img30.imageshack.us/i/add2d.jpg/
Addendum 2e - http://img688.imageshack.us/i/add2e.jpg/

Could someone do this? I don't know even how to start, I don't understand it

 

[Deleted member 4993]

The sale of article X is measured on a weekly basis, The company uses various sales promoting parameters such as radio, web, store, and shop commercials etc. In the following these parameters are Called A, B, and C. The sale and parameter costs per week are shown in addendum 1.

Addendum 2 shows a number of regression analyses that all explain the sale by the parameters A, B and C - individually or combined.

1) Coment on the regression analyses set up in addendum 2 and estimate which of the models explains the sale of article x best.

In the following the management of XYZ decides to use parameter A solely to explain the sale of commodity X. See addenda 2c and 2f.

2) Set up a model showing sale as a function of parameter A. Determine and comment on the coefficients of the model.

3) Examine and comment on whether the assumptions of the model are met.

4) Assume that the costs for parameter A is 101. Calculate a 95% prediction interlval for the sale of the week in question.
Addendum 1 - http://img594.imageshack.us/i/add1n.jpg/
Addendum 2a - http://img30.imageshack.us/i/add2a.jpg/
Addendum 2b - http://img340.imageshack.us/i/add2b.jpg/
Addendum 2c - http://img163.imageshack.us/i/add2c.jpg/
Addendum 2d - http://img30.imageshack.us/i/add2d.jpg/
Addendum 2e - http://img688.imageshack.us/i/add2e.jpg/

Could someone do this? I don't know even how to start, I don't understand it

After somebody does this - would you present his/her work as your own - or would declare in there that somebody else solved these for you.

We do not do homework here - we help.

You need to start and do some work - and show us your work.

Please share your work with us, indicating exactly where you are stuck - so that we may know where to begin to help you.

 

[2suchy7]

I will be having this on exam, but this is only an example of a question. I have been tried to do this but i don't know even how to start. I am terrible in statistics. So maybe someone explain me how to do this all question (in excel), you don't need to solve.