#### Details of this Paper

##### DSS220 D12 & D13 Business Analytics-Spring 2014 Midterm

Description

solution

Question

Question;DSS220 D12 & D13 Business Analytics-Spring 2014MidtermExhibit 1.1 Is a summary table of drive times, measured in minutes, showing a random sampleof six people in each of the following four cities: Houston, Charlotte, Tucson, Akron. Means andvariance are supplied in the table. The grand mean for the summary table is 36.625. Thevalues in Exhibit 1.1 for each of the questions below are the same. It is only necessary tocompute the one way ANOVA once.Exhibit 1.1 A researcher with Ministry of Transportation is commissioned to study the drive times to work(one-way) for U.S. cities. The underlying hypothesis is that average commute times are different acrosscities. To test the hypothesis, the researcher randomly selects six people from each of the four cities andrecords their one-way commute times to work. Refer to the below data on one-way commute time (inminutes) to work. Note that the grand mean is 36.625.Refer to Exhibit 1.1. Question 1: The value of the test statistic is:A. 0.06B. 0.40C. 2.51D. 16.75Exhibit 1.1 A researcher with Ministry of Transportation is commissioned to study the drive times to work(one-way) for U.S. cities. The underlying hypothesis is that average commute times are different acrosscities. To test the hypothesis, the researcher randomly selects six people from each of the four cities andrecords their one-way commute times to work. Refer to the below data on one-way commute time (inminutes) to work. Note that the grand mean is 36.625.Refer to Exhibit 1.1. Question 2: At the 5% significance level, the critical value is:A. 2.38B. 3.10C. 3.86D. 4.94DSS220 D12 & D13 Business Analytics-Spring 2014MidtermExhibit 1.1 A researcher with Ministry of Transportation is commissioned to study the drive times to work(one-way) for U.S. cities. The underlying hypothesis is that average commute times are different acrosscities. To test the hypothesis, the researcher randomly selects six people from each of the four cities andrecords their one-way commute times to work. Refer to the below data on one-way commute time (inminutes) to work. Note that the grand mean is 36.625.Refer to Exhibit 1.1. Question 3: The p-value for the test is:A. Less than 0.01B. Between 0.01 and 0.025C. Between 0.025 and 0.05D. Greater than 0.05Exhibit 1.1 A researcher with Ministry of Transportation is commissioned to study the drive times to work(one-way) for U.S. cities. The underlying hypothesis is that average commute times are different acrosscities. To test the hypothesis, the researcher randomly selects six people from each of the four cities andrecords their one-way commute times to work. Refer to the below data on one-way commute time (inminutes) to work. Note that the grand mean is 36.625.Refer to Exhibit 1.1. Question 4: The conclusion for the hypothesis test is:A. Reject the null hypothesis, cannot conclude that not all mean commute times are equalB. Do not reject the null hypothesis, cannot conclude that not all mean commute times are equalC. Reject the null hypothesis, not all mean commute times are equalD. Do not reject the null hypothesis, not all mean commute times are equalQuestion 5: The purpose of data visualization is to:A. Communicate information clearly through graphical meansB. Stimulate viewer engagement and attentionC. Allow people to easily identify patternsD. All of the aboveDSS220 D12 & D13 Business Analytics-Spring 2014MidtermRefer to Exhibit 1.2. Question 6: A hedge fund manager needs to achieve a 16% return on herportfolio in order to make her clients happy AND to buy her new get-a-way place in Grand Cayman(complete with catamaran, speed boat and parasail). She has collected the most recent 12 months ofreturns data for her primary holdings shown in Exhibit 1.2. With equal allocation, the return for theportfolio is 12.086%.JanFebMarAprMayJunJulAugSepOctNovDecMeanReturnsJSDA0.1560.0450.0320.020-0.1780.1360.1790.2300.0470.3830.0090.5020.130Stock ReturnsCOKEWFM0.3360.1550.4460.023-0.0490.021-0.0560.0880.0890.1570.2270.0150.5840.0290.0830.1660.0800.0430.6770.0260.0650.0220.3130.0980.2330.070TBILL0.0500.0500.0500.0500.0500.0500.0500.0500.0500.0500.0500.0500.050Refer to Exhibit 1.2. Question 6: What will be the percent allocation for Jones Soda (JSDA) forportfolio to return 16%?A. 0.09B. 0.00C. 0.12D. 0.13Refer to Exhibit 1.3. Question 7: General Mills announced the launch of reformulated "whole grain"versions of its cereals at the same time it is closing its Black Foot plant. Grain elevators supplying thegrain are located in Duluth, MN, and St. Louis, MO, while manufacturing plants are located in Black Foot,ID, Cedar Rapids, IA, and Albuquerque, NM. Capacities and costs are indicated in the table.General Mills Supply ChainDataCOSTS \$/TonDuluth Elevator ASt. Louis Elevator S&XSLACK SUPPLYDemandBlack Foot36.8120.40999CedarRapids11.828.52999Albuquerque41.2831.35999486000040500007290000SLACKDEMANDSupply9999999990Refer to Exhibit 1.3. Question 7: The current minimum transportation cost is \$ 431,859,600.When General Mills closes its Black Foot plant, the new minimum transportation cost will be:A. 284,455,800B. 147,403,800C. 579,263,400D. Cannot be determined given the information.97200006480000016200000 \16200000

Paper#36770 | Written in 18-Jul-2015

Price : \$37