Sheet1 salt (in...

Question

Sheet1
    salt (in tons)
    1111
    2115
    1573
    2813
    2815
    2126
    854
    3965
    1819
    776
    1484
    2056
    784
    779
    1373
    1237
    1701
    1957
    246
    1730
    2365
    1902
    2858
    2236
    1718
    916
    2830
    2865
    1574
    1373
Real data,however, the names and place have been changed to make this more fun.
Massachusetts Highway Department Civial Engineers Steph, Steph, Bill and Steve, keep track of the amount of road salt they order from a salt mine in Chile. The salt is spread on state highways to keep them drivable in a snowstorm.
Here is their data from the 30 storms from the winter of 2020.
They calculate a mean of 1,798 tons of salt. Verify this calculation.
What can you assert about using this mean as the basis for future orders? They want to be 95% confident that there is enough salt for the next winter.
Please write your answer below and show your calculations

mia-l2kqvqlf.xlsx road-salt-0h3sd0jy.xlsx

Yasodharan · Accepted Answer

Summer 2019 Exam 3 Auto M
	Intro Stats
	Summer 2019
	Labor (time in hours)
	2.15													Labor (time in hours)
	2.27
	0.99													Mean	1.8646153846
	0.63													Standard Error	0.1733324911
	2.45													Median	1.35
	1.3													Mode	2.27
	2.63													Standard Deviation	1.2499183684
	2.2													Sample Variance	1.5622959276
	0.99													Kurtosis	-0.0163107214
	1													Skewness	0.8675727973
	1.05													Range	5
	3.44													Minimum	0.2
	0.49													Maximum	5.2
	0.93													Sum	96.96
	2.52													Count	52
	1.05													Confidence Level(95.0%)	0.3479794959
	1.39
	1.22
	3.17
	0.85
	1.18
	2.27
	1.52
	0.48
	1.33
	4.2
	1.37
	2.7
	0.63
	1.13
	3.81
	0.2
	1.08
	2.92
	2.87
	2.62
	1.

Sheet1 salt (in tons) 1111 2115 1573 2813 2815 2126 854 3965 1819 776 1484 2056 784 779 1373 1237 1701 1957 246 1730 2365 1902 2858 2236 1718 916 2830 2865 1574 1373 Real data,however, the names and...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment