Determine what is asked through Microsoft Excel. A food delivery man wants to estimate the amount of money spent for gasoline based on the total distance he has travelled in a day. He randomly...


Determine what is asked through Microsoft Excel.<br>A food delivery man wants to estimate the amount of money spent for gasoline based on the total<br>distance he has travelled in a day. He randomly selected 11 working days in his first month in this<br>delivery job.<br>Distance<br>60<br>65<br>50<br>40<br>25<br>69<br>70<br>45<br>47<br>58<br>62<br>travelled<br>|(x)<br>Amount 455.9 500 300.5 310.25 250.50 458 500<br>400 450.5 490.10 510.25<br>spent on<br>gasoline<br>(y)<br>Determine the strength of the relationship of variable x and y by finding the value of correlation<br>coefficient and coefficient of determination. Then, Interpret the results.<br>

Extracted text: Determine what is asked through Microsoft Excel. A food delivery man wants to estimate the amount of money spent for gasoline based on the total distance he has travelled in a day. He randomly selected 11 working days in his first month in this delivery job. Distance 60 65 50 40 25 69 70 45 47 58 62 travelled |(x) Amount 455.9 500 300.5 310.25 250.50 458 500 400 450.5 490.10 510.25 spent on gasoline (y) Determine the strength of the relationship of variable x and y by finding the value of correlation coefficient and coefficient of determination. Then, Interpret the results.

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here