Fill In All Highlighted Yellow Cells Please R

Datafill In All Cells That Are Highlighted In Yellowplease Remember To

Datafill In All Cells That Are Highlighted In Yellowplease Remember To

Data FILL IN ALL CELLS THAT ARE HIGHLIGHTED IN YELLOW Please remember to save this file with your last name in the file name. For example: Name: Annual Amount Spent on Organic Food Age Annual Income Number of People in Household Gender (0 = Male; 1 = Female) Questions 1 -3 FILL IN ALL CELLS THAT ARE HIGHLIGHTED IN YELLOW QUESTION 1: Create a scatterplot in Excel with “Annual Amount Spent on Organic Food†on the y (vertical) axis and “Age†on the x (horizontal) axis. QUESTION 2: Insert a trendline. QUESTION 3: What does the trendline indicate about the relationship between these two variables? Age Annual Amount Spent on Organic Food Recall: Click on the "Insert" tab and Choose the Scatterplot Chart. Recall: You can insert a trendline by "right-clicking" on the coordinates on the scatterplot and choosing the "Add Trendline" option. Questions 4-8 FILL IN ALL CELLS THAT ARE HIGHLIGHTED IN YELLOW QUESTION 4: Calculate the correlation coefficient for these two variables using the =CORRELATION() formula in Excel. QUESTION 5: Interpret the correlation coefficient QUESTION 6: Does the correlation coefficient agree with the slope of the best fit line? Explain. 5. QUESTION 7: Add the equation for the best fit line on the chart. QUESTION 8: Does this equation match the linear regression equation from the Case for this Module? Explain. Recall: To add the equation to the chart, right- click on the trendline and choose "Format Trendline." Then, choose the box next to: "Display Equation on Chart." Note: Keep in mind the equation is for the trendline, so it will take on the normal structure of an equation for a line: y = mx + b, where m is the slope, and b is the y-intercept. The regression equation will take on the following structure: y = α + bx, where b is the slope and α is the y-intercept.