Statistics Questions Need Excel Spreadsheet Filled Out
Statistics Questions Need Excel Spreadsheet Filled Out
I am attaching an Excel Spreadsheet that has all of the things I need to input. Answers alone will not help me. I need all of the parts of the equation filled out. Any answers I put in are probably wrong.
Evergreen Fertilizer Company produces fertilizer. The company’s fixed monthly cost is $25,000,
and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per
pound. Determine the monthly break-even volume for the company.
Q- 12
If Evergreen Fertilizer Company in Problem 4 changes the price of its fertilizer from $0.40 per
pound to $0.60 per pound, what effect will the change have on the break-even volume?
Q – 14
14. If Evergreen Fertilizer Company increases its advertising expenditures by $14,000 per year, w
effect will the increase have on the break-even volume computed in Problem 13?
Chapter 11
Q- 18
The following probabilities for grades in management science have been determined based on past
records:
Grade Probability
A .10
B .30
C .40
D .10
F .10
1.00
The grades are assigned on a 4.0 scale, where an A is a 4.0, a B a 3.0, and so on. Determine the
expected grade and variance for the course.
Q- 26
The weight of bags of fertilizer is normally distributed, with a mean of 50 pounds and a standard
deviation of 6 pounds. What is the probability that a bag of fertilizer will weigh between 45 and
55 pounds?