Tuesday
July 29, 2014

Homework Help: Business Statistics

Posted by Katie on Wednesday, December 14, 2011 at 4:12pm.

Instructions: Prepare your answers using Excel and show your work to get full or partial credit.
Question 1:

Using the file Wages.xlsx which contains information of working individuals, for a nationwide firm (Value 7 points).


a) Run Descriptive Statistics for the variables Education, Number of siblings, Motherís years of education and Fatherís years of education. Show your output. What is the mean of each of these variables? What is the number of observations (n)?


b) Estimate a regression equation of education on the number of siblings, motherís years of education and fatherís years of education as independent variables. Show the Excel output.


c) Write the Sample Regression Function


d) Interpret the coefficients of the regression


e) Are the coefficients statistically significant at the 95% confidence level? Write down the hypothesis that you are testing for each coefficient, and explain your conclusions.


f) Suppose that Tom has 3 siblings, and his mother has 10 years of education and his father has 14 years of education. Henry has no siblings, and his mother and father each has 16 years of education. Using the regression equation, calculate the estimated education for Tom and Henry


g) What is the predicted difference in years of education between Tom and Henry?

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

Statistics - Select a random sample of 30 student responses to question 6, "How ...
Statistics - Select a random sample of 30 student responses to question 6, "How ...
Excel - Please prepare the homework problems in the form of a Word and/or Excel ...
Strategic Management - Using the Bacardi website, develop both EFAS and IFAS ...
Statistics - Below Find a sequence of probabilites generated using excel.What is...
geometry - User: Courtney Thompson In Course: Geometry V8 ( 2167) Instructor: ...
statistics - My mean is 175.5 My standard deviation is=90.57 Sample=25 ...
Business Analytics statistics - I dont under stand ho to get the answer to this ...
college Algebra - 1) Solve the following by factoring: a) Answer: Show your work...
Chicago Manual (CM) and Council of Science Editors - Question 1 5 points Save ...

Search
Members