Hello, attached are all the questions I need help with that need to be answered, Please. Each question is under its own tab on excel. Please just answer under the red colored area and attach back the answers.
For question 1(1a-1d), the data is:
It appears that over the past 50 years, the number of farms in United States declined while the average size of farms increased. The following data provided by the U.S. department of agriculture show five-year interval data for U.S. farms.
Year Number of Farms(millions) Average Size(acres)
1950 5.65 213
1955 4.65 258
1960 3.96 297
1965 3.36 340
1970 2.95 374
1975 2.52 420
1980 2.44 426
1985 2.29 441
1990 2.15 460
1995 2.07 469
2000 2.17 434
2005 2.10 444
2010 2.19 419
For question 2(2a-2c), Use the question 2 input data given in the excel tab
For question 3(3a-3b), Use the question 3 input data given in the excel tab
For question 4(4a-4c), Use the question 4 input data given in the excel tab
For question 5(5a-5e), the statement in text states:
The Springfield Emergency Medical Service keeps records of emergency telephone calls. A study of 150 five-minute time intervals resulted in the distribution of number of calls that follows. for example, during 18 of the 5-minute intervals, no calls occurred. The data is:
Number of Calls(per 5 min intervals) Frequency
0 18
1 28
2 47
3 21
4 16
5 11
6 or more 9