Create a scatter plot of Y on the vertical axis

Assignment Help Applied Statistics

Reference no: EM131989227

Statistics for Business and Economics Assignment -

Part A - Instructions for Dataset 3: Simple Regression Analysis

A statistic lecturer wanted to test the theory: the longer one studied, the better one's grade. Accordingly, he took a random sample of 100 students and asked each student to report the average amount of time he or she studies statistics and the final mark received.

The data file dataset3.xls contain data of 100 students and the variables in the dataset are:

Mark (Y, final mark in points (out of 100))
Time (X, study time in hours)

The dependent variable for your analysis is Mark.

Answer the following questions using dataset 3.

(a) Create a scatter plot of Y on the vertical axis against X on the horizontal axis (make sure to label each axis).

(b) Using the scatter plot in (a), does there appear to be a relationship between Y and X? If so, in what direction is the relationship? How strong is the relationship?

(d) Interpret the intercept coefficient. Does it make sense?

(e) Interpret the slope coefficient.

(f) Compute the coefficient of determination and interpret its meaning.

(g) Compute the standard error of the estimate and interpret its meaning. Judge the magnitude of the standard error of the estimate.

(h) Perform a residual analysis (plot the residuals) and evaluate whether the assumptions of regression have been violated.

(i) Test for the significance of the slope coefficient using t test (follow all the necessary steps). Assume 5% level of significance.

(j) Test for the slope using F test (follow all the necessary steps). Assume 5% level of significance.

(k) Compute a 95% confidence interval estimate of the mean Y for all students when X = 24 and interpret its meaning.

(l) Compute a 95% prediction interval of Y for a student when X = 24 and interpret its meaning.

Part B - Instructions for Dataset 4: Multiple Regression Analysis

The data file dataset4.xls contains information on monthly earnings, experience, IQ scores and race for 855 men.

The variables in the dataset are:

Wage (monthly earnings in dollar)
Experience (years of work experience)
Black (1 if black and 0 if nonblack)
IQ (IQ score)

The dependent variable for your analysis is Wage.

Answer the following questions using dataset 4.

(a) Estimate a regression model using Experience and IQ to predict Wage (present the output and write out the estimated equation).

(b) Interpret the slope coefficients.

(d) Plot the residuals to test the assumptions of the regression model. Is there any evidence of violation of the regression assumptions? Explain.

(e) Determine the variance inflation factor (VIF) for each independent variable (Experience and IQ) in the model. Is there reason to suspect the existence of collinearity?

(f) Are all individual variables significant at the 5% level? Use t tests and follow all the necessary steps.

(g) Test for the significance of the overall multiple regression model at 5% level of significance.

(h) Estimate a regression model using Experience, IQ and Black to predict Wage (present the output, and write out the multiple regression equation, the regression equation for blacks and the regression equation for nonblacks). Interpret the coefficient for Black.

(i) Test the hypothesis that there is wage discrimination against blacks at the 5% level.

(j) Estimate a regression model using Experience, IQ, Black, and an interaction between Black and Experience to predict Wage (present the output and write out the estimated equation). Interpret the coefficients of Experience and the interaction term.

(k) Test whether the return to experience depends on race at the 5% level.

Attachment:- Assignment Files.rar

Reference no: EM131989227

Questions Cloud

Do you think that australia could better address this issue : Aboriginal people are over-represented in the criminal justice and prison systems.

How much federal income tax they will save : How much Federal income tax they will save if Ella quits her job. Any tax benefits that might be available from the cost of the education.

Write about one body paragraph for steve jobs : Quality of three famous people who are Richard Branson, Steve Jobs, and Opera Winfrey.

Can peoples intentions to use alcohol tell us anything : PSY247 :Are the attitudes, subjective norms, and perceived behavioural control all related to general community members intention to use alcohol ?

Create a scatter plot of Y on the vertical axis : ECON7300: Statistics for Business and Economics Assignment - Create a scatter plot of Y on the vertical axis against X on the horizontal axis

How islamic financial system is different : How Islamic Financial System is different from Conventional Financial System (If the paragraph double spaces) Please give me best price

How do politics affect the success of a fire officer : How do politics affect the success of a fire officer? Is it possible to make decisions without regard to their political impact on the department?

Use of wireless access in a healthcare organization : What are two concise policy statements regarding the use of wireless access in a healthcare organization?

Independent investigation into networking related topics : ITECH1102 Networking and Security - Content Analysis ePortfolio Assignment - conduct an independent investigation into networking related topics from books

User Account

All Pages