Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please open the attached Final 22 EXCEL. XLS file. The file contains closing prices for two stocks: AGG and VOO. Use this data to answer

image text in transcribedimage text in transcribed
Please open the attached Final 22 EXCEL. XLS file. The file contains closing prices for two stocks: AGG and VOO. Use this data to answer questions 6 through 10. Final 22.xIsx Calculate the sample variance for the stock VOO. Enter your answer as a number to 3 decimal places. For example, 27.625 should be entered as 27.625. Help: The data is contained here if you cannot open the EXCEL file. Count AGG VOO 1 111.95 360.06 IN 112.03 359.13 3 112.05 360.56 112.43 364.38 U A 112.2 369.64 6 112.6 369.43 112.42 369.89 Co 112.7 371.69 9 112.57 374.37 10 112.54 374.54 11 112.86 375.55 12 112.78 374.35 13 113.22 378.37 14 112.92 379.69 15 112.83 377.82 16 113.01 375.05 17 113.12 378.57 18 113.15 375.1 19 113.13 379.1 20 113.03 379.92 21 112.76 379.8 22 112.81 379.62 23 112.76 382.16 24 112.87 379.63 25 112.95 380.49Please use the data in Question # 6 to answer the following question: Calculate the mean price of A66. Enter your answer as a number to 3 decimal places. For example, 27.625 should be entered as 27.625. QUESTION 8 4points 5 Please use the data in Question # 6 to answer the following question: Calculate the correlation coefcient between A66 and V00. Enter your answer as a decimal to 3 decimal places. For example, 0.0925 should be entered as 0.0925 QUESTION 9 4points 5 Please use the data in Question # 6 to answer the following question: Calculate the third quartile, inclusive, of V00. Enter your answer as a decimal to 3 decimal places. For example, 400.251 should be entered as 400.251 QUESTION 10 4points 5 Please use the data in Question # 6 to answer the following question: Use AGG as the independent variable X and V00 as the dependent variable Y to calculate the amount of variance in V00 explained by the variance in AGG. Hint: Use EXCEL's regression tool to calculate the model's R Square (R2). Enter your answer as a decimal to 3 decimal places. For example, 0.0925 should be entered as 0.0925

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Probability Models

Authors: Sheldon M Ross

12th Edition

0128143460, 9780128143469

More Books

Students also viewed these Mathematics questions

Question

Get married, do not wait for me

Answered: 1 week ago

Question

Do not pay him, wait until I come

Answered: 1 week ago

Question

Do not get married, wait until I come, etc.

Answered: 1 week ago