Search for question
Question

Last week we looked at r, r², and the line of best fit. Please download the attached file which contains the latest data on Covid-19 cases in Washington State

(Source: https://www.kingcounty.gov/depts/health/covid-19/data.aspx B). The tabs at the bottom of the spreadsheet, present different variables of interest.

Use the table feature above, choose any TWO variables from this spreadsheet,type all the data for the two variables and find r, r², and if the relationship between

the two variables is linear, please also find the equation relating the two variables. You may want to choose only 30 days of data. Data presented is for 119 days.

Comment if the linear relationship is strong, weak or if there is no relationship as well. Present graphs using Excel or any other software with the trend line

embedded?