Determine best degree program in terms of projected income

Assignment Help Applied Statistics
Reference no: EM13752619

Problem 1

The director of career advising at Orange Community College wants to use decision analysis to provide information to help students decide which 2-year degree program they should pursue. The director has set up the following payoff table for six of the most popular and successful degree programs at OCC that shows the estimated 5-year gross income ($) from each degree for four future economic conditions:

Degree Program

Economic Conditions

Recession

Average

Good

Robust

Graphic Design

145,000

175,000

220,000

260,000

Nursing

150,000

180,000

205,000

215,000

Real Estate

115,000

165,000

220,000

320,000

Medical Tech

130,000

180,000

210,000

280,000

Culinary Tech

115,000

145,000

235,000

305,000

Computer IT

125,000

150,000

190,000

250,000

Probability

0.2

0.4

0.3

0.1

Determine the best degree program in terms of projected income, using the following decision criteria:

a. Maximax

b. Maximin

c. Equal likelihood

d. Hurwicz (alpha = .6)

e. Minimax regret

f.  EOL (expected opportunity loss)

g. The director of career advising at Orange Community College has paid a small fee to a local investment firm to indicate a probability for each future economic condition over the next 5 years, which is shown in the last row of the above table. Using expected value determine the best degree program in terms of projected income.

h. Determine the EVPI of this problem.

Problem 2

The Americo Oil Company is considering making a bid for a shale oil development contract to be awarded by the federal government. The company has decided to bid $112 million. The company estimates that it has a 60% chance of winning the contract with this bid. If the firm wins the contract, it can choose one of three methods for getting the oil from the shale. It can develop a new method for oil extraction, use an existing (inefficient) process, or subcontract the processing to a number of smaller companies once the shale has been excavated. The results from these alternatives are as follows:

            Develop new process:                                                               Use present process:

Outcomes

Probability

Profit ($1,000,000s)

Great success

.30

$ 600

Moderate success

.60

300

Failure

.10

-100

Outcomes

Probability

Profit ($1,000,000s)

Great success

.50

$ 300

Moderate success

.30

200

Failure

.20

-40

Subcontract:

Outcome

Probability

Profit ($1,000,000s)

Moderate success

1.00

250

The cost of preparing the contract proposal is $2 million. If the company does not make a bid, it will invest in an alternative venture with a guaranteed profit of $30 million. Construct a sequential decision tree for this decision situation and determine whether the company should make a bid.

Problem 3

Consider the following data from a small bookstore.
Number of sales people working------Sales (in $1000)
2---------------------10
3---------------------11
7---------------------13
9---------------------14
10---------------------18
10---------------------20
12---------------------20
15---------------------22
16---------------------22
20---------------------26
x = 10.4------------------y = 17.6
SD(x) = 5.64----------------SD(y) = 5.34

1. Calculate the mean and standard deviation of # of sales people (x) and sales (y). Find sample size n.

2. Calculate the correlation coefficient with all three methods (covariance method, z-score method, and correlation tool in Excel).

3. Find b0 and b1 for the linear regression model with all three methods (two different formulas and Solver). Interpret the meaning of b1 of this linear regression model.

4. Calculate Se and SST.

5. Calculate R square with both methods (correlation coefficient method and the formula r square = 1 - SSE/SST). Interpret the meaning of R square of this linear regression model.

6. Use Regression tool in Excel to find b0, b1, SSE, SST, r, R square, and Se.

7. Estimate the sales if the number of sales people working is 8, 13, and 19, respectively.

Problem 4

The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 12 months:

Month  Gasoline Demanded (gal.)

October               800

November          725

December           630

January                                500

February              645

March                   690

April                       730

May                       810

June                      1,200

July                        980

August                  1,000

September         850

  1. Compute a 2-month moving average demand forecast for the months of December to September. Calculate MAD, MAPD and MSE.
  2. Compute the optimal 2-month weighted moving average demand forecast for the months of December to September. Calculate MAD, MAPD and MSE.
  3. Assume the demand forecast for October is equal to the actual demand of October, 800. Compute the optimal exponentially smoothed demand forecast for the months of November to September. Calculate MAD, MAPD and MSE.
  4. Assume the demand forecast for October is 800 and trend for October is 0. Compute the optimal double exponentially smoothed demand forecast for the months of November to September. Calculate MAD, MAPD and MSE.
  5. Compute linear trend line demand forecast for the months of October to September. Calculate MAD, MAPD and MSE.
  6. Compare the five forecasting methods by using MAD, MAPD and MSE and indicate which method is the best fit for the data based on MAD, MAPD (or MAPE), and MSE, respectively.

Problem 5

Consider a project which consists of the following set of activities:

Activity

Days Required

Immediate Predecessor Activities

A

3

--

B

4

A

C

4

A

D

3

A

E

3

D

F

4

B

G

6

B

H

5

F, C, E

I

6

G, H

J

4

F, C, E

K

2

D

L

6

I, J, K

  1. Draw the CPM network for this problem in Excel.
  2. Calculate the earliest and latest start and finish times, and the slack for each activity.
  3. Identify (Highlight) the critical path.
  4. Create a Gantt chart for this project in Excel.

Reference no: EM13752619

Questions Cloud

How can the falling us dollar impact your travel expenses : How can the falling U.S. dollar impact your travel expenses and Why would a cheap dollar relative to other nations' currencies be good or bad for U.S. trade?
Great success but made ethical mistakes to pay a big prize : Find companies that had a great success but made ethical mistakes to pay a big prize in the end. Who was the key person responsible for this loss
How advent of home video technology change us film industry : How did the advent of home video technologies change the American film industry? In what ways did the studios-who in 1976 regarded home video as a competitor-exploit these technologies to their advantage?
How to deal with annoying co-workers : Read the article entitled, How to deal with annoying co-workers. Write a paper about your thoughts on this article. Additionally, in your paper, be sure to address the following:
Determine best degree program in terms of projected income : Determine the best degree program in terms of projected income, using the following decision criteria Maximax - Maximin and Using expected value determine the best degree program in terms of projected income.
Why is the nfs option grayed out on the share protocols page : Why is the NFS option grayed out on the Share Protocols page and According to the Server Manager console, what roles are currently installed on the computer
What is the benefit of creating multiple levels of dfds : What is the benefit of creating multiple levels of DFDs? Consider the concept of DFD consistency. Why is consistency important to take advantage of the multiple levels of DFDs that may be created
Techniques for conflict management : 1. A collectivist Chinese manager is most likely to use which of the following techniques for conflict management?
Why is the nfs option grayed out on the share protocols page : Why is the NFS option grayed out on the Share Protocols page and According to the Server Manager console, what roles are currently installed on the computer

Reviews

Write a Review

 

Applied Statistics Questions & Answers

  Let x be the sample mean of a random sample of size n

Let X be the sample mean of a random sample of size n from a uniform distributionon the interval [0, b], and let bb = 2X be an estimator of the upper endpoint b.(a) Demonstrate that bb is an unbiased estimator of b, and find the variance of th..

  Condence interval fornbspmu when sigma is knownsuppose n 9

condence interval fornbspmu when sigma is knownsuppose n 9 people are selected at random from a large population.

  Q1 in a pure exchange economy with two goods g and h two

q1. in a pure exchange economy with two goods g and h two traders amos and elise have cobb-douglas utility functions.

  Create a separate histogram for each day

Festival Histogram: Beginning with in the text on spotting outliers, correct the type in the data as directed - create a separate histogram for each day, Day1, Day2, and Day3, using the hygiene variable for all three days. Include the normal curve

  Researchable hypothesis for accounts receivable

Researchable hypothesis for Accounts Receivable

  How would you describe their difference

What are the different types of non-probability sampling? What are the different types of probability sampling? How would you describe their difference?

  Glendale westgate restaurant location

John and Mario, owners of Mi Casa Front Porch Restaurant are planning a big Super Bowl event for their Glendale Westgate restaurant location and have received a permit for additional outside seating.

  Bay area community college

6. Bay Area Community College (BACC) has collected data comparing the starting salaries of their graduating students with last names beginning with the letters A through M with those whose last names begin with N through Z. The first category,..

  Appropriate formatting and verbiage for a college-level

Create a scenario based on your work, school, home or other place and describe how you could use the knowledge and skills you've developed in the class to help answer a question or solve a problem.In a minimum of 500 words create a scenario us..

  Find the mean, variance and standard deviation

Find the mean, median, mode, variance and standard deviation for the following nine data values and find the four quartiles and the 20 th and 80 th percentiles for the above data.

  This assignment requires a considerable amount of computer

this assignment requires a considerable amount of computer work and written comment. you may need to seek guidance from

  Determine an out of control process

Search the Internet, your textbook, or other materials to learn more about control charts. Explain how control charts can be used to detect processes that are possibly out of statistical control. Identify the warning signs that are used to determine ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd