Homework #2 | Mathematics homework help


IE 151 Homework #2

Continue after a while Microsoft Excel

                You are going to reverse in one Excel refine after a while each of the problems on another spreadsheet after a whilein the refine, spontaneous formal opposedly.

1)      We are looking at the distinction in the mediocre rain per month among New Mexico and Arizona.  We ponder that the whole of rain aggravate the progress of a year should be common to each other, specifically about Las Cruces (for New Mexico) and Tucson (for Arizona).  The postulates placid (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 batch and note if the wholes of rain are common to each other for the two areas for a year.

 

2)      Calculate the forthcoming probabilities after a while the similar distribution:

·         Normal Distribution, using a medium of 20 and plummet intermission of 10:

o   Find a = 12, not cumulative

o   Find a = 23, cumulative

o  

o  

·         Poisson Distribution, using a trounce correspondent to 15:

o   Find a = 14, not cumulative

o   Find a = 19, cumulative

o  

o  

·         Gamma Distribution, using a cast 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 illustration after a while opposed levels of ingredients and how they interest the tallness that a set merit become.  Each of the opposed scenarios are conducted twice, to succor secure over accutrounce results.  The chief ingredient that was looked at was the whole of yellow inconsiderable, and had two levels, 50% and 60%.  The cooperate ingredient that was considered was the whole of red inconsiderable, and three levels were considered, 10%, 15%, and 20%.  The latest ingredient was the whole of cerulean inconsiderable, 5%, 10%, and 15%.  Any cherishing inconsiderable is filtered sun inconsiderable.  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, solution the forthcoming questions:

·         What is the aggravateall mediocre of the observations?

·         Regardless of the whole of yellow inconsiderable, what is the mediocre tallness if we use 15% red inconsiderable and 5% cerulean inconsiderable?

·         What is the aggravateall acme compute of the postulates?

·         What is the aggravateall reserve compute of the postulates?

 

4)      We are started for a sodality that builds machinery for mining.  There are a sure sum of ingredients that we use in command for use to dispose-of the machinery.  The sodality has been guardianship course of the sales sums for the late six months, and they would affect a sum of questions solutioned.  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 specie gone-by on opposed operations in the sodality are vivid as follows:

·         Administrative Expenses are rate 10%

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

·         Marketing gets a budget of 10%

·         Employees merit a deputation of 5% of the sum sales

·         The gain lip then becomes 60%

There is so an opening for our duty to merit a benefit from the sales.  However, the whole of the benefit is resting on the whole of sales.  The whole of benefit is conducive as:

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

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

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

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

By using a what-if separation, skill wants to recognize, what do the forthcoming computes insufficiency to shift to if we are unprovided to perform a gain of $6,500,000? (It’s ok to put your solutions on another spreadsheet)

a.       If we are to shift the gain lip percentage, what does it insufficiency to be?

b.      If we are to shift the authoritative percentage, what does it insufficiency to be?

 

c.       If we are to shift the deputation percentage, what does it insufficiency to be?