{"id":106,"date":"2022-10-07T12:28:48","date_gmt":"2022-10-07T16:28:48","guid":{"rendered":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/linear-regression-and-correlation-excel-tools-instruction\/"},"modified":"2023-01-20T14:23:05","modified_gmt":"2023-01-20T19:23:05","slug":"linear-regression-and-correlation-excel-tools-instruction","status":"publish","type":"chapter","link":"https:\/\/opentextbc.ca\/busstatsancillary\/chapter\/linear-regression-and-correlation-excel-tools-instruction\/","title":{"raw":"Linear Regression and Correlation - Excel Tools Instruction","rendered":"Linear Regression and Correlation – Excel Tools Instruction"},"content":{"raw":"
Download Linear Regression and Correlation \u2013 Excel Instructions Data Sets [XLSX]<\/a>.<\/div>\r\n

Scatter Plot<\/h1>\r\nA scatter plot graph<\/strong> presents the data set where it is hypothesized that Y is dependent upon the single independent variable X.\r\n

Scatter Plot in Excel<\/h2>\r\n
    \r\n \t
  1. Highlight columns of<\/span> cells<\/li>\r\n \t
  2. Click Insert, Scatter<\/span> and the one with only Markers<\/span><\/li>\r\n \t
  3. Click on the new Scatter plot<\/span> to change Title<\/span>, and click icon +<\/span><\/strong> to make other changes<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
    x (third exam score)<\/th>\r\ny (final exam score)<\/th>\r\n<\/tr>\r\n
    65<\/td>\r\n175<\/td>\r\n<\/tr>\r\n
    67<\/td>\r\n133<\/td>\r\n<\/tr>\r\n
    71<\/td>\r\n185<\/td>\r\n<\/tr>\r\n
    71<\/td>\r\n163<\/td>\r\n<\/tr>\r\n
    66<\/td>\r\n126<\/td>\r\n<\/tr>\r\n
    75<\/td>\r\n198<\/td>\r\n<\/tr>\r\n
    67<\/td>\r\n153<\/td>\r\n<\/tr>\r\n
    70<\/td>\r\n163<\/td>\r\n<\/tr>\r\n
    71<\/td>\r\n159<\/td>\r\n<\/tr>\r\n
    69<\/td>\r\n151<\/td>\r\n<\/tr>\r\n
    69<\/td>\r\n159<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n[caption id=\"attachment_105\" align=\"aligncenter\" width=\"382\"]\"\" Step 1 & 2: Highlight columns of cells. Click Insert, Scatter and the one with only Markers[\/caption]\r\n\r\n[caption id=\"attachment_105\" align=\"aligncenter\" width=\"613\"]\"\" Step 3: Click on the new Scatter plot to change Title, and click icon + to make other changes[\/caption]\r\n

    Media Attributions<\/h3>\r\n