Use Excel Spreadsheets, Google Sheets, or GeoGebra to create a scatter plot for the data below. (You will upload your graph in the next question.) Use the graph to answer the questions below the table.  The following data are the morning and evening high tide levels for Charleston, SC from January 1-14,2017. The information for the PM high tide for January 4 is missing. Create a scatter plot. Find the regression line and use it to estimate the PM high tide for January 4. Then find the correlation coefficient. (NOTE: The first column identifies the day. This data will not be used in the scatter plot.)  Day AM High (in feet), xx PM High (in feet), yy 1 5.6 4.8 2 5.5 4.8 3 5.4 4.9 4 5.2   5 5.0 5.1 6 5.2 5.0 7 5.4 4.9 8 5.7 5.0 9 6.0 5.1 10 6.3 5.3 11 6.4 5.4 12 6.5 5.4 13 6.4 5.4 14 6.2 5.3

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

Use Excel Spreadsheets, Google Sheets, or GeoGebra to create a scatter plot for the data below. (You will upload your graph in the next question.) Use the graph to answer the questions below the table. 

The following data are the morning and evening high tide levels for Charleston, SC from January 1-14,2017. The information for the PM high tide for January 4 is missing. Create a scatter plot. Find the regression line and use it to estimate the PM high tide for January 4. Then find the correlation coefficient. (NOTE: The first column identifies the day. This data will not be used in the scatter plot.)

 Day AM High (in feet), xx PM High (in feet), yy
1 5.6 4.8
2 5.5 4.8
3 5.4 4.9
4 5.2  
5 5.0 5.1
6 5.2 5.0
7 5.4 4.9
8 5.7 5.0
9 6.0 5.1
10 6.3 5.3
11 6.4 5.4
12 6.5 5.4
13 6.4 5.4
14 6.2 5.3

Source: SCDHEC.gov

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON