• Home
  • Blog
  • statistics questions need excel spreadsheet filled out

statistics questions need excel spreadsheet filled out

0 comments

Week ONE (1).xlsx 

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.

Q 2- The Retread Tire Company recaps tires. The fixed annual cost of the recapping operation is $60,000. The variable cost of recapping a tire is $9. The company charges $25 to recap a tire. a. For an annual volume of 12,000 tires, determine the total cost, total revenue, and profit. b. Determine the annual break-even volume for the Retread Tire Company operation. 

Q-4 

 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?

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post statistics questions need excel spreadsheet filled out appeared first on Nursing Writers Hub.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}