# Statistics Questions Need Excel Spreadsheet Filled Out

**Question description**

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- 12If 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 11Q- 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?

## Tutor Answer

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors