Operations Management - Decision Analysis Projects

The file xls contains data obtained from surveys of customers of DS and Associates, Inc. collected through

2. The file xls contains data obtained from surveys of customers of DS and Associates, Inc. collected through a market research firm. Variables X1 through X7 are customer perceptions of the firm, variables $\mathrm{X} 9$ and $\mathrm{X} 10$ are purchase outcomes, and variables X8, and X11 through X14 are characteristics of the purchasers (i.e., the companies surveyed by the market research firm). Using your knowledge of multivariate statistics answer the following questions providing proper documentation of your solutions, the methods employed, and any assumptions you had to make.

Can customer perceptions be grouped? If so what is an appropriate grouping?
Can the customer perception data be reduces to a smaller number of variables?
Can a good equation be developed to predict either usage level and/or satisfaction level? What equation(s) were you able to develop? Would you recommend any of them for use by the firm?

3. The attached data represents an attempt to predict the peak temperature experienced by a metal structure to be placed in service in the desert of the southwest US. Data on the peak wind speed, ambient temperature, humidity, and solar radiation have been collected as predictors. Approximately two months’ worth of service data on these predictors have been collected and are attached.

Use the data to build a regression model which will predict structural peak temperatures. Use as many variables as you need; you may wish to use stepwise regression in order to determine which variables are necessary. Describe your model building technique and examine the properties (residual plots, etc.) of your chosen model. Finally, provide $95 \%$ prediction intervals for the structural temperature for the following conditions:

Wind Speed	Ambient Temperature	Ambient Humidity	Solar Radiation	Structure Temperature
51.83	97.5	69.57	305.9	127
46.55	105.9	52.5	310.3	135.1
91.8	104.6	51.23	303.2	127.1
72	104.2	47.13	305.4	129.8
94.3	102.8	45.61	303.6	124.7
83.1	104.9	38.31	322.3	130.8
57.36	105	40.21	299	134.2
44.39	101.4	45.69	333.3	136.6
53.9	103.8	44.03	311.4	134.5
54.12	107.7	42.33	306.5	141.2
55.81	95.2	51.19	308.5	130.7
70.2	101.9	50.83	313.8	130.2
54.65	105.6	47.47	302.2	136.7
37.1	108	39.3	314.5	147.1
55.34	110.5	64.59	307.7	147.7
40.11	103	79.4	299.6	134.8
65.44	110.6	45.39	297.9	139.7
68.66	110.5	54.61	313.7	134.9
109.7	109.2	39.87	305.1	129.3
131.1	110.3	38.72	307.9	129.7
110	112.5	37.33	292.6	132.8
108.1	112	37.24	298	132.4
84.3	112.2	38.27	292.7	135.2
70.9	106.8	41.43	303	131.4
51.6	105.4	94.1	287	148
40.22	106.6	103	320.8	145.5
62.23	112.3	34.54	286.3	142.8
67.33	113.5	37.89	310.7	141.6
42.46	109.4	43.15	310.8	145.1
54.16	112.4	41.1	314	141.8
98.5	112.5	38.28	323.6	135.1
82.5	111.2	39.24	312.2	139
94.6	113.6	35.32	309.1	134.6
83.7	113	36.4	306.4	138.1
100.1	109.3	40.07	305.4	132.9
107.8	109.9	35.94	297.3	130.9
67.85	109.7	33.1	302.4	138.2
56.78	108.1	32.6	303.1	138.9
94.6	113	35.28	299.3	136.1
70.8	114.1	33.88	296.5	142.7
97.6	112	33.99	301.8	135.1
61	111.8	37.54	299.8	143.8
99.3	113.1	36.1	301.4	135.6
57.05	112.1	40.28	287.2	142.6
78.1	109.2	37.4	294.5	146.4
76.8	112.1	37.82	294.2	139.9
64.61	112.2	36.36	298.1	144.4
105.4	114.5	37.13	279.3	135.6
95.8	113.9	36.92	301.1	138.3
79.9	111.6	45.54	282.7	141
58.34	113.3	58.41	283.1	148.8
61.72	108.1	52.49	271	136.7
57.03	115.5	34.78	300.6	142.6
63.59	114.9	38.49	273.2	149.2
67.93	112.9	63.54	305.9	143.2
58.53	109.8	105.4	279.6	140.9
50.22	104.2	104.6	288.6	137.1
43.93	113.2	63.79	281.2	147.6
69.7	116.7	38.04	290.1	146.7
57.64	108.2	57.77	288.1	142.7
47.56	111.2	58.33	261.3	143.5
72.3	116.7	54.81	292.5	143.7
69.98	117.3	38.83	285.5	142.9
71.8	111.1	37.08	296.6	139.7

4. There are $n$ people in a room. Ignoring leap year, what is the probability that no one in the room shares your birthday? Explain the probability law and/or laws that you used to solve this problem and its assumptions.

5. Draw a normal probability distribution. Label the parameters of this distribution, i.e. the mean and the standard deviation.

5.1. Now, assume you take repeated random samples of sizes $\mathrm{n}=1$ from this population. If you calculate $\bar{X}$ for each sample and plot the distribution, draw the distribution of $\bar{X}$ and label the parameters of that distribution.

5.2. Now, assume you take repeated random samples of sizes $n=4$ from this population. If you calculate $\bar{X}$ for each sample and plot the distribution, draw the distribution of $\bar{X}$ -and label the parameters of that distribution.

5.3. Now, assume you take repeated random samples of sizes $\mathrm{n}=30$ from this population. If you calculate $\bar{X}$ for each sample and plot the distribution, draw the distribution of $\bar{X}$ and label the parameters of that distribution.

5.4. Draw another continuous probability distribution. (Any distribution except a normal distribution. ) Label the parameters of this distribution. Now, assume you take repeated random samples of sizes $\mathrm{n}=30$ from this population. If you calculate $\bar{X}$ for each sample and plot the distribution, draw the distribution of $\bar{X}$ and label the parameters of that distribution. List your assumptions.

6. Consider the following data.

Perform COMPLETE regression analysis for the data above, including listing your assumptions, explaining how you would test those assumptions, and why you would use or not use the least squares equation.

7. Using the data in #3, test the hypothesis that the mean of $X$ is less than the mean of $Y$. List your assumption(s).

20. A project has the following activities, durations, costs, and precedence relationships:

First, disregarding the acceleration information, perform CPM analysis on the project. Draw a CPM network for the project. Compute the EF, LF, and Slack for each activity. Write the values on the CPM network. What is the critical path? What is its length?
Develop a cost-time trade-off analysis. Detail the steps that you would use to accelerate or crash the project to its minimum duration at the lowest cost. Determine each step's cost and the duration of the project.

Price: $41.38

Solution: The downloadable solution consists of 26 pages, 1538 words and 32 charts.
Deliverable: Word Document