Essay Introduction to Economic Methods – Computing Assignment – Statistics Assignment Help

Assignment Task

INTRODUCTION TO ECONOMIC- METHODS COMPUTING ASSIGNMENT
In this assignment you are required to use the relevant built-in function in Excel to estimate a simple linear regression model. As essential preparation for this assignment you should have worked through the computing exercise sets.

Suppose the managers of a telemarketing company are interested in the relationship between the following two variables:

The sales revenue in dollars (say Y) generated by a telemarketer in his/her first year of completed service.
The number of hours of preliminary training provided to a new telemarketer (say X).

Using a random sample of data for 42 telemarketers that recently completed their first year of service with the company, you are required to estimate a conditional expectation function of the following form by least squares regression using the Microsoft Excel regression tool.

To generate your own personalised data set you will need to follow the steps below.
Open the ‘Assignment Data Generation File’ attachment in the ‘Computing Assignment’ link on the left hand menu of the vUWS site for this unit. If the Excel file opens in ‘Protected View’, just click on ‘Enable Editing’ before undertaking the following steps.
Once you have opened the Data Generation File in Excel, you should enter the last four digits of your student number in the range of cells E2 to H2, i.e. with the fifth digit in E2, the sixth digit in F2, the seventh digit in G2, and the eighth digit in H2. This will generate your personalised data set in the range A1:C43 (with the headings ‘Marketer’, ‘Hours of Training’ and ‘Sales Revenue’ in A1, B1 and C1, respectively). Note that the marker of your assignment will be able to check that you use the correct data set corresponding to your student number.