Homework Assignment #8Name: Tyler DekarskeAll calculations should be done in Word using Equation Editor and all charts and graphs shouldbe done in Excel.Use the output below to answer the following questions.A financial advisor wants to know if there is a relationship between ING and investmentbanking. Does ING predict good investments in banking? The results are as follows:Regression StatisticsR SquareAdjusted R SquareObservations0.89210.87428ANOVAdfRegressionResidualTotalVariableInterceptInvestmentsSSMSF1??7180.214321.7857??180.2143????Coefficient-0.32144.1429StandardError1.48480.5881T value????P value0.83580.0004SignificanceF0.00041Lower95%????1)Fill in the tables with the missing values? (You should have 10 different values you need to find)2)What is the correlation coefficient of the model?Upper95%????3)What is the correlation of determination?4)What is the estimated regression equation?5)Interpret the slope.6)What is the hypothesis scenario?7)Use the estimated regression equation to predict INQ with an Investment of 6.8)Would your predicted in #7 be interpolation or extrapolation? Why? (Hint: Use the 95% ConfidenceInterval for reference)9)Is there evidence of a significant relationship between ING and Investments? Use alpha = .05.10)One pair of data in this sample is (2, 5). Which says that Investments of 2 had an ING of 5,calculate a residual for this data point. (Hint: calculate the difference between the observed ING andpredicted ING)11)What is the standard error of the estimated regression line?
We Write Essays for Students
Tell us about your assignment and we will find the best writer for your paper
Get Help Now!The post Homework Assignment #8Name: Tyler DekarskeAll calculations should be done in Wor appeared first on Infinite Essays.
Welcome to originalessaywriters.com, our friendly and experienced essay writers are available 24/7 to complete all your assignments. We offer high-quality academic essays written from scratch to guarantee top grades to all students. All our papers are 100% plagiarism-free and come with a plagiarism report, upon request
Tell Us “Write My Essay for Me” and Relax! You will get an original essay well before your submission deadline.
