# Quantitative Economics Watch

Announcements
1. I NEed som help with a quantitave economics coursework..which is excel based..if anyone has attempted it before..

3. here is a part of the course work question Simple Linear Regression Model

1) Plot 2 separate scatter diagrams of demand for coffee, Y, against, , real price of coffee and real personal disposable income, .
What kind of relationship does each scatter diagram present? Explain.
10 marks

2) Assuming that demand for coffee, , and real price of coffee, are linked by a linear relationship, estimate this regression by Ordinary Least Squares (OLS) method, clearly showing all your calculations ( Excel can be used for all the computations).

(1)

Write out the estimated regression equation. Draw the estimated
regression line on your scatter graph. Clearly interpret the coefficient
estimates and . Conduct an appropriate test at 5% significance level
on the slope coefficient to examine its statistical significance. Clearly
state the null and alternative hypothesis. Draw appropriate graph to
Comment on your significance test result. Present the scatter diagram, all
your computations, and summary regression output.
4. There aren't really any steps as Excel gives you a regression equation directly from the data.

It should all be very straightforward for you, just tell us which bit you don't get and we can help.
5. how does the coursework look?..because i have completed the first question on excel and i have got a lot on my plate already
6. It looks very very very easy. How about you try and do your own coursework.
7. i would if i could but no time..and have done so..
8. (Original post by yugii)
i would if i could but no time..and have done so..
I understand. Okay don't worry about it, I'll do it and send you it all on the 10th .
9. (Original post by yoyo462001)
I understand. Okay don't worry about it, I'll do it and send you it all on the 10th .
I could believe you bt thn that would be a very big set up 2 DAYS BEFORE!!!

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: December 30, 2010
Today on TSR

### Things NOT to do at uni

Have you done any of these?

### How much revision have yr12s done?

Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• Poll
Discussions on TSR

• Latest
• ## See more of what you like on The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

• The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.