Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Estimate beta of PFE relative to S&P500 using daily price data for one year ended August 7, 2020. Also compute the alpha and R-squared.

/in /by

Hello tutor, could you help me with this question. This is my first

time attend finance class, I am very confused about how can I use Excel to get the answer. Thank you for your explanation.

Estimate beta of PFE relative to S&P500 using daily price data for one year ended August 7, 2020. Also compute the alpha and R-squared.

In addition to computing alpha, beta and R-squared, you are expected to plot the observations in an XY Scatter graph (with returns on PFE on the vertical axis and returns on S&P500 on the horizontal axis), choose to “Add Trendline,” (choose “Linear”), and also choose to display the equation and RSQ on the graph.

You are also expected to make sure that the answers to alpha, beta and R-squared that you computed agree with those that appear in the equation on the graph.

Upload the Excel file.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"