LAB WORK (EXCEL) Date McDonald's Corp S 59.53 30-Jan-09 27-Feb-09 56.21 31-Mar-09 53.31 30-Apr-09 55.19 29-May-09 55.01 30-Jun-09 58.25 31-Jul-09 57.07 31-Aug-09 55.79 30-Sep-09 55.92 30-Oct-09 58.02 30-Nov-09 62.72 31-Dec-09 62.32 Federal Funds Rate (Effective) FED 0.15 0.22 0.18 0.15 0.18 0.21 0.16 0.16 0.15 0.12 0.12 0.12 US Industrial Production Index Level (Federal Reserve) IP 88.50 87.20 86.50 85.70 85.50 86.70 87.80 88.40 88.60 89.10 89.60 90.50 From the given data of stock price of McDonald's Corp (S), US Federal Funds Rate (FED), and US Industrial Production Index (IP), provide the answer the following questions - a. Generate mean, median, mode, standard deviations, variance, range, minimum and maximum values for all the three variables of interest. Also give your interpretations. b. Generate the correlations matrix from MS excel and interpret the results. c. Get the excel results for Multiple Regression assuming McDonald's Corp share price (S) as dependent variable and FED and IP as independent variables. d. Write down the fitted multiple regression equation derived from the MS excel. e. Interpret two B's Test the Individual significance of the regression hypothesis at the 5% level of significance. 2. Test the Overall significance of the regression hypothesis at the 5% level of significance h. Interpret R Square.
LAB WORK (EXCEL) Date McDonald's Corp S 59.53 30-Jan-09 27-Feb-09 56.21 31-Mar-09 53.31 30-Apr-09 55.19 29-May-09 55.01 30-Jun-09 58.25 31-Jul-09 57.07 31-Aug-09 55.79 30-Sep-09 55.92 30-Oct-09 58.02 30-Nov-09 62.72 31-Dec-09 62.32 Federal Funds Rate (Effective) FED 0.15 0.22 0.18 0.15 0.18 0.21 0.16 0.16 0.15 0.12 0.12 0.12 US Industrial Production Index Level (Federal Reserve) IP 88.50 87.20 86.50 85.70 85.50 86.70 87.80 88.40 88.60 89.10 89.60 90.50 From the given data of stock price of McDonald's Corp (S), US Federal Funds Rate (FED), and US Industrial Production Index (IP), provide the answer the following questions - a. Generate mean, median, mode, standard deviations, variance, range, minimum and maximum values for all the three variables of interest. Also give your interpretations. b. Generate the correlations matrix from MS excel and interpret the results. c. Get the excel results for Multiple Regression assuming McDonald's Corp share price (S) as dependent variable and FED and IP as independent variables. d. Write down the fitted multiple regression equation derived from the MS excel. e. Interpret two B's Test the Individual significance of the regression hypothesis at the 5% level of significance. 2. Test the Overall significance of the regression hypothesis at the 5% level of significance h. Interpret R Square.
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter7: Exponents And Exponential Functions
Section: Chapter Questions
Problem 68SGR
Related questions
Question
Transcribed Image Text:LAB WORK (EXCEL)
US Industrial
Production Index
Level (Federal
Reserve)
Federal Funds Rate
(Effective)
Date
McDonald's Corp
FED
IP
30-Jan-09
27-Feb-09
31-Mar-09
30-Apr-09
29-May-09
30-Jun-09
31-Jul-09
31-Aug-09
30-Sep-09
30-Oct-09
30-Nov-09
31-Dec-09
59.53
0.15
88.50
56.21
0.22
87.20
53.31
0.18
86.50
55.19
0.15
85.70
55.01
0.18
85.50
58.25
0.21
86.70
57.07
0.16
87.80
55.79
0.16
88.40
55.92
0.15
88.60
58.02
0.12
89.10
62.72
0.12
89.60
62.32
0.12
90.50
From the given data of stock price of McDonald's Corp (S),
US Federal Funds Rate (FED), and US Industrial
Production Index (IP), provide the answer the following
questions -
a. Generate mean, median, mode, standard deviations,
variance, range, minimum and maximum values for all
the three variables of interest. Also give your
interpretations.
b. Generate the correlations matrix from MS excel and
interpret the results.
c. Get the excel results for Multiple Regression assuming
McDonald's Corp share price (S) as dependent variable
and FED and IP as independent variables.
d. Write down the fitted multiple regression equation derived
from the MS excel.
e. Interpret two B's
£ Test the Individual significance of the regression
hypothesis at the 5% level of significance.
e Test the Overall significance of the regression hypothesis
at the 5% level of significance
h. Interpret R Square.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 6 steps with 4 images
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill