Question: !!PLEASE ANSWER WITH EXCEL SPREADSHEET!! Say that global temperatures could change over the next several decades and you have it on good advice that the

!!PLEASE ANSWER WITH EXCEL SPREADSHEET!!

Say that global temperatures could change over the next several decades and you have it on good advice that the change (in degrees Celsius) is equal to the percentage change in CO^2 use in the USA times .2 and then you would add the percentage change in CO^2 use in the rest of the world times .8. Over the time period the percentage change in CO^2 use in the USA is expected to fall with a uniform distribution between -10 and -6 percent and the percentage change in CO^2 use in the rest of the world has a normal distribution with mean of 2.2 percent increase and a standard deviation of .1. (Think of 2.2 percent, for example, as 2.2 and not 0.022.)

  1. Simulate 1000 trials of global temperature change.
  2. In your simulation, what is the probability that global temperatures will DECLINE (that is, percentage change is negative)?

Note your global temperature change =

[(some uniformly distributed variable) times 0.2] + [(some normally distributed variable) times .8]

Also note the uniform variable has lower value -10 and upper value -6, so you have

-10 + [(-6 (-10))*rand()]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!