Chapter 4, Problem 1 Using Excel, conduct a regression analysis, d...

  1. Home
  2. Homework Library
  3. Business
  4. Econometrics
  5. Chapter 4, Problem 1 Using Excel, conduct a regression analysis, d...

QuestionQuestion

Transcribed TextTranscribed Text

Chapter 4, Problem 1 Using Excel, conduct a regression analysis, determine if there is a meaningful relationship between grades and SAT scores? In your answer to part a, include discussion on the significance of the model, coefficient of determination, signs of the coefficients and p-values for the variables. Using the regression results you obtained in part a, predict the GPA of a student that scores 1400 on the SAT. Show your calculations or receive a maximum of half credit on part b and c. What about a student who scores 2010? A monthly forecast model for computers was developed and the results are displayed below. C = 68.38 -6.50(P) + .139(M) where C = Number of computers sold P - Computer price M= Consumer Income (a) Forecast the demand for computers when P = $500 and M = $30,000 (b) Estimate the demand for computers when P = $600 and M = 33,000? (c) What other factors would you consider when forecasting the demand for computers?? Show all calcuations for parts a and b. (d) Suppose that the data for C is available on a monthly basis for the past two years. Are there any other forecasting models you would consider for forcasting the demand for computers? If so, identify and explain the model(s). (e) Chapter 4, Problem 2 Thirteen students entered the undergraduate business program at Albertus Magnus College 2 years ago. The following table indicates what their grade-point averages (GPAs) were after being in the program for 2 years and what each student scored on the SAT exam (maximum 2400) when he or she was in high school. STUDENT SAT SCORE GPA A 1273 2,90 B 1150 2,93 C 1790 3,00 D 2090 3,45 E 1874 3,66 F 1090 2,88 G 1235 2,15 H 1450 2,53 I 2195 3,22 J 1290 1,99 K 1839 2,75 L 2127 3,90 M 980 1,60 Show how your arrive at all of your answers: 2a. 2b. 2c. Chapter 4, Problem 1 Using Excel, conduct a regression analysis, determine if there is a meaningful relationship between grades and SAT scores? In your answer to part a, include discussion on the significance of the model, coefficient of determination, signs of the coefficients and p-values for the variables. Using the regression results you obtained in part a, predict the GPA of a student that scores 1400 on the SAT. Show your calculations or receive a maximum of half credit on part b and c. What about a student who scores 2010?

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.xlsx.

    50% discount

    Hours
    Minutes
    Seconds
    $20.00 $10.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Econometrics Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats