Having a choice of either using ANOVA or using regression. Discuss either 1 or 2.
1. Divide data in half, your first 8 observations and your last 7 observations. Then use ANOVA to test to see if there is a significant difference between the two halves of your data. This list of Webpages that Perform Statistical Calculations has several ANOVA calculators.
2. Count the total number of observations you have, and label this number N. Then create another set of data starting from one and increasing by one until you reach N. For example, if you have 10 observations, then your new set of data would be (1, 2, 3, 4, 5, 6, 7, 8, 9, 10). This set of data is called a time series. Run a regression using your original set of data as your dependent variable, and your time series as an independent variable. Use the simple regression calculation page to calculate your regression. Write a short paper reporting your results and any conclusions that can be reached with it.
The data collected on the attached spreadsheets were recorded over a 15 day period, Monday thru Friday, morning and afternoon. I recorded the number of people that walked into my office.© BrainMass Inc. brainmass.com June 3, 2020, 11:41 pm ad1c9bdddf
A Complete, Neat and Step-by-step Solution is provided in the attached Excel file.