Applied Business Statistics for Business Managers using Excel

You need to answer this with excel, I just send it to you how to use excel to do these problems. Please follow the instruction that I send to you in the file.

“Practice Problems”

1.
The data in the Beverage file represents the amount of fluid in a sample of fifty 2-l bottles. Using the data from the file, complete the following exercises.
(a)
Construct a frequency distribution.

(b)
From the output, what is the mean?

(c)
From the output, what is the standard deviation?

2.
The data in the Electric file represents the cost of electricity in June for a random sample of fifty one-bedroom apartments in a large city in the southern portion of the United States. Using the data from the file complete the following exercises.
(a)
Construct a frequency distribution.

(b)
Construct a histogram.

(c)
Around what amount does the monthly electricity cost seem to center?”

Last Completed Projects

topic title academic level Writer delivered