I am not exactly sure how to do the following: 2.On each worksheet tab (other than the
No answer yet for this question.
Ask a Tutor
Question:
I am not exactly sure how to do the following:
2.On each worksheet tab (other than the data table tab) include:
a.a copy of your data entry screen (Use Alt+Print Screen to copy picture of Regression Data Entry from Data Analysis in Excel and paste on correct worksheet tab).
b.The regression model derived from the data tables.
c.Line Fit Plot for each Worksheet tab.
d.Labels of the data included.
e.Highlight with yellow and label the following four items on each regression model:
i.Coefficient of determination
ii.Coefficient of correlation or covariance
iii.Slope, and
iv.Beta or intercept
Posted Date: