--%>

correlation analysis and the regression statistics

1).  When you take out a mortgage, there are many different kinds of costs.  Usually the two largest are the interest rate (annual percentage that determines the size of your monthly payment) and the loan fee (a one-time percentage charged to you at the time the loan is made).  Based on the data in the MORTAGE tab of the Excel file provided, what type of relationship exists between the interest rate and loan fee?  How strong of a relationship exists between these two variables?  If one wanted to predict the loan fee given a certain interest rate, would you recommend using a model derived from this data?  Only use correlation analysis and the regression statistics to briefly justify your reasoning.  Use α = .05.  

2).  The data in the MATH tab of the Excel file provided represents a sample of mathematics achievement test (MAT) scores and calculus grades for independently selected college freshmen.  From this evidence, would you say that the achievement test scores and calculus grades are independent? 

Use α = .01.  

3).  Part of a study to determine factors influencing family medical expenses involves finding a regression relationship between the number of people in a family and the monthly medical expense.  The data for the pilot study is located in the MEDICAL tab in the Excel file provided. 

            a).  Develop a regression model at the .05 level of significance.

b).  What can be said regarding the slope and correlation coefficient?  Conduct both the (t)-test and F-test for the slope, and (t)-test for the correlation coefficient.

c).  Use your results in (a) to determine the monthly medical expenses for a family of (4)?  Is this meaningful?

d).  Use your results in (a) to determine the monthly medical expenses for single person household?  Is this meaningful?

 

4).  Consider the earnings per share and the closing stock price of selected biotechnical firms with large market capitalization located in the STOCK tab in the Excel file provided.  Given the importance of many analysts place on earnings per share, you might expect to find a strong correlation between earnings per share and stock price.  Of course, it may be premature to judge since the market price may depend more on the expectation of (random) future earnings than on the actual achieved earnings.  (20 pts)

 

            a).  Draw a scatterplot of the stock price against earnings per share.

            b).  Determine the coefficient of determination and interpret its meaning.

            c).  Using α = .05, develop a regression model.

d).  Conduct a residual analysis and determine the validity of the model.  Include the Durbin-Watson test.

e).  You are head of a biotech firm planning to go public soon.  Your earnings per share are $.05.  Based on your model in (c), what stock price would you anticipate.

 

5).  A sample of 30 computer hardware companies were observed from Stock Investor Pro and is located in the INVESTOR tab in the Excel file provided.  The data includes price per share, book value per share, and the return on equity per share for each. 

a).  Develop an estimated regression model that can be used to predict the price per share given the book value per share and the return on equity per share.  Use the .05 level of significance.

b).  Test the significance of the overall regression model.

c).  Use the (t)-test and partial F-test to determine the significance of each independent variable.

d).  Do the independent variables make a significant contribution to the regression model?  Which one(s) should be included?

            e).  Compute the coefficients of partial determination and interpret the results.

            f).  Add an interaction term to the model.  Does it make a significant contribution to the model?

6).  Your firm is worried about being sued for gender discrimination.  There is a growing perception that males are being paid more than females in your department.  Using the data in the SALARY tab in the Excel file provided, please complete the following using α = .05: 

            a).  Do the men appear to earn more on average than women based on the information provided?

            b).  Derive a regression model, and provide a model for men and a model for women.

c).  Do the independent variables make a significant contribution to the regression model?  Which one(s) should be included?

            d).  Compute the coefficients of partial determination and interpret the results.

            e).  Add an interaction term to the model.  Does it make a significant contribution to the model?

            f).  How does the salary differ for men and women if each one has 13-years experience?

            g).  Does your results imply discrimination against women?

   Related Questions in Basic Statistics

  • Q : Derived quantities in Queuing system

    Derived quantities in Queuing system: • λ = A / T, Arrival rate • X = C / T, Throughput or completion rate • ρ =U= B / T, Utilization &bu

  • Q : Compute two sample standard deviations

    Consider the following data for two independent random samples taken from two normal populations. Sample 1 14 26 20 16 14 18 Sample 2 18 16 8 12 16 14 a) Com

  • Q : Get Solved LP Problems Solve Linear

    Solve Linear Programming Questions A producer manufactures 3 models (I, II and III) of a particular product. He uses 2 raw materials A and B of which 4000 and 6000 units respectively are obtainable. The raw materials per unit of 3

  • Q : Problem on queuing diagram Draw a 

    Draw a queuing diagram for the systems below and describe them using Kendall’s notation: A) Single CPU system <

  • Q : Report on Simple Random Sampling with

    One of my friend has a problem on simple random sampling. Can someone provide a complete Report on Simple Random Sampling with or without replacement?

  • Q : Write out the null hypothesis 1.

    1. (AAC/ACA c9q1).  For each of the following studies, decide whether you can reject the null hypothesis that the groups come from identical populations. Use the alpha = .05 level.1a.

  • Q : State Littles Law Little’s Law : • L =

    Little’s Law: • L = λR = XR • Lq = λW = XW • Steady state system • Little’s Law holds as long as customers are not destroyed or&nbs

  • Q : Building Models Building Models • What

    Building Models • What do we need to know to build a model?– For model checking we need to specify behavior • Consider a simple vending machine – A custome rinserts coins, selects a beverage and receives a can of soda &bul

  • Q : MANOVA and Reflection Activity

    Activity 10:   MANOVA and Reflection   4Comparison of Multiple Outcome Variables This activity introduces you to a very common technique - MANOVA. MANOVA is simply an extension of an ANOV

  • Q : Use the NW corner rule to find an

      (a) Use the NW corner rule to find an initial BFS, then solve using the transportation simplex method. Indicate your optimal objective function value. (b) Suppose we increase s1 from 15 to 16, and d3 from 10 to 11. S

  • ©TutorsGlobe All rights reserved 2022-2023.