Homework #2 | Mathematics homework help


IE 151 Homework #2

Continue delay Microsoft Excel

                You are going to rotate in one Excel polish delay each of the problems on another spreadsheet delayin the polish, normal methodic incorrectly.

1)      We are looking at the estrangement in the moderation rain per month among New Mexico and Arizona.  We consider that the whole of rain aggravate the mode of a year should be congruous to each other, specifically encircling Las Cruces (for New Mexico) and Tucson (for Arizona).  The axioms self-possessed (in inches) is as follows:

Month

New Mexico

Arizona

January

0.51

1.02

February

0.39

0.94

March

0.24

0.87

April

0.28

0.31

May

0.39

0.2

June

0.67

0.28

July

1.54

1.93

August

2.2

2.24

September

1.34

1.22

October

0.94

1.22

November

0.47

0.67

December

0.79

1.02

Data Source: www.usclimatedata.com

Construct a box conspire and criticise if the wholes of rain are congruous to each other for the two areas for a year.

 

2)      Calculate the forthcoming probabilities delay the corresponding distribution:

·         Normal Distribution, using a moderation of 20 and flag discontinuance of 10:

o   Find a = 12, not cumulative

o   Find a = 23, cumulative

o  

o  

·         Poisson Distribution, using a rebuke resembling to 15:

o   Find a = 14, not cumulative

o   Find a = 19, cumulative

o  

o  

·         Gamma Distribution, using a model parameter of 5 and layer parameter of 2:

o   Find a = 10, not cumulative

o   Find a = 15, cumulative

o  

o  

 

3)      We are conducting an test delay divergent levels of ingredients and how they seek the altitude that a establish succeed amplify.  Each of the divergent scenarios are conducted twice, to aid determine gone-by accurebuke results.  The original ingredient that was looked at was the whole of yellow easy, and had two levels, 50% and 60%.  The cooperate ingredient that was considered was the whole of red easy, and three levels were considered, 10%, 15%, and 20%.  The conclusive ingredient was the whole of cerulean easy, 5%, 10%, and 15%.  Any fostering easy is filtered sun easy.  The observations that were witnesses are as follows:

Yellow Light

Red Light

Blue Light

Observations

50%

10%

5%

12,13

50%

10%

10%

14,15

50%

10%

15%

15,15

50%

15%

5%

12,11

50%

15%

10%

11,13

50%

15%

15%

13,12

50%

20%

5%

15,16

50%

20%

10%

16,15

50%

20%

15%

14,15

60%

10%

5%

10,10

60%

10%

10%

11,12

60%

10%

15%

15,13

60%

15%

5%

13,12

60%

15%

10%

12,10

60%

15%

15%

10,11

60%

20%

5%

14,15

60%

20%

10%

13,15

60%

20%

15%

14,13

 

Using pivot tables, confutation the forthcoming questions:

·         What is the aggravateall moderation of the observations?

·         Regardless of the whole of yellow easy, what is the moderation altitude if we use 15% red easy and 5% cerulean easy?

·         What is the aggravateall consummation rate of the axioms?

·         What is the aggravateall minimum rate of the axioms?

 

4)      We are instituted for a society that builds machinery for mining.  There are a actual sum of ingredients that we use in adjust for use to hawk the machinery.  The society has been custody mark of the sales sums for the gone-by six months, and they would love a sum of questions confutationed.  The sales figures are as follows:

·         August 2014 - $4,565,853.22

·         September 2014 - $5,263,558.15

·         October 2014 - $6,187,998.38

·         November 2014 - $4,962,347.75

·         December 2014 - $4,248,654.46

·         January 2015 - $3,956,874.59

The whole of the money departed on divergent operations in the society are descriptive as follows:

·         Administrative Expenses are merit 10%

·         Overhead (Rent, Utility Bills, etc.) are merit 15%

·         Marketing gets a budget of 10%

·         Employees merit a errand of 5% of the completion sales

·         The improvement latitude then becomes 60%

There is as-well an opening for our duty to merit a benefit from the sales.  However, the whole of the benefit is relative on the whole of sales.  The whole of benefit is fitted as:

·         If sales are aloft or resembling to $6,000,000, then a benefit of $100,000 is given

·         If sales are under $6,000,000, but aloft or resembling to $4,500,000, a benefit of $50,000 is given

·         If sales are under $4,500,000, then no benefit is given

·         Hint: You are going to demand to use two IF functions in one formula

By using a what-if resolution, conduct wants to comprehend, what do the forthcoming rates demand to diversify to if we are unprovided to compel a improvement of $6,500,000? (It’s ok to put your confutations on another spreadsheet)

a.       If we are to diversify the improvement latitude percentage, what does it demand to be?

b.      If we are to diversify the functional percentage, what does it demand to be?

 

c.       If we are to diversify the errand percentage, what does it demand to be?