Business Statistics

posted by .

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?

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. geometry

    User: Courtney Thompson In Course: Geometry V8 ( 2167) Instructor: Tracie Morgan -------------------------------------------------------------------------------- WARNING: You must not leave this exam form! If you try to click back …
  2. college Algebra

    1) Solve the following by factoring: a) Answer: Show your work here: b) Answer: Show your work here: 2) If , find a) f(2) Answer: Show your work here: b) f(-1) Answer: Show your work here: 3) Solve 6x2 + 3x – 18 = 0 using the quadratic …
  3. Strategic Management

    Using the Bacardi website, develop both EFAS and IFAS table using an excel file. Also including both environmental and internal scanning process and what factors you consider and why will typed in MS word file.
  4. Business/ Strategic Management

    If you don't mind if you could give me TWO PRICES one for 1.) full assignment Deliverable Length:Tables count for 2 pgs and 4 pages in MS Word format Due Date: 6/18/2010 latest 6/19/2010 Research the British Petroleum website. Using …
  5. Excel

    Please prepare the homework problems in the form of a Word and/or Excel file. Try to use one file to submit your answers, if possible, and include the questions with your answers. You must show your calculations. 1. Your nursing home …
  6. Business

    Research the Goldman Sachs website. Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are …
  7. Statistics

    Select a random sample of 30 student responses to question 6, "How many credit hours are you taking this term?
  8. Statistics

    Select a random sample of 30 student responses to question 6, "How many credit hours are you taking this term?
  9. Business Statistics

    The Bureau of Labor Statistics’ American Time Use Survey showed that the amount of time spent using a computer for leisure varied greatly by age. Individuals age 75 and over averaged 0.30 hour (18 minutes) per day using a computer …
  10. MATH PLS HELP

    19 WorkPad Note: In questions 19-21, remember to show all of the steps that you use to solve the problem. Be sure to use the text box where the question mark (?

More Similar Questions