Question: Solve the problem with the following data: create a formatted table presenting the data in a new worksheet. Add a new column for call hour
Solve the problem with the following data: create a formatted table presenting the data in a new worksheet. Add a new column for call hour which begins at 0 and increase to 47. Create a mathematical model for an 18 hour period from the data set. The period will include one high tide and one low tide. Consider a linear model, an exponential model, a power model and a polynomial model, select the best model. The model used to describe the tide must account for at least 97% of the variation. Display the equation and measure of variation on the graph. Data: Date Day Time Pred Call Hour 12/28/2024 Sat 0:00 12.81 0 12/28/2024 Sat 1:00 11.12 1 12/28/2024 Sat 2:00 8.93 2 12/28/2024 Sat 3:00 6.94 3 12/28/2024 Sat 4:00 5.78 4 12/28/2024 Sat 5:00 5.83 5 12/28/2024 Sat 6:00 7.2 6 12/28/2024 Sat 7:00 9.62 7 12/28/2024 Sat 8:00 12.43 8 12/28/2024 Sat 9:00 14.94 9 12/28/2024 Sat 10:00 16.54 10 12/28/2024 Sat 11:00 16.65 11 12/28/2024 Sat 12:00 15.07 12 12/28/2024 Sat 13:00 12.12 13 12/28/2024 Sat 14:00 8.38 14 12/28/2024 Sat 15:00 4.66 15 12/28/2024 Sat 16:00 1.8 16 12/28/2024 Sat 17:00 0.38 17 12/28/2024 Sat
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
