Question: PLEASE USE EXCEL TO SOLVE A study to determine the correlation between bank deposits and consumer price indices in Birmingham, Alabama, revealed the following (which

PLEASE USE EXCEL TO SOLVE

PLEASE USE EXCEL TO SOLVE A study to determine

A study to determine the correlation between bank deposits and consumer price indices in Birmingham, Alabama, revealed the following (which was based on n=5 years of data): = 15 x2 = 55 Exy = 70 y = 20 y? = 130 a) The equation of the least square regression line is (round your responses to one decimal place): = 1 + 1x b) The coefficient of correlation, r, = 0.44 (round your response to two decimal places). The correlation coefficient indicates that there is a positive correlation between bank deposits and consumer price indices in Birmingham, Alabama c) The standard error of the estimate = 0.51 (round your response to two decimal places)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!