Write the null and alternative hypothesis for a two-tailed test for each of the following variables: (10 points)
Student Ht Wt Age (Yrs) Shoe Size Waist Size Pocket
Change
01 64 180 39 07 36 018
02 66 140 31 09 30 125
03 69 130 31 09 25 151
04 63 125 36 07 25 011
05 68 155 24 08 31 151
06 62 129 42 06 32 214
07 63 173 30 08 34 138
08 60 102 26 06 25 067
09 66 180 33 08 30 285
10 66 130 31 09 30 050
11 63 125 32 08 26 032
12 68 145 33 10 28 118
13 75 235 44 12 40 060
14 68 138 43 08 27 050
15 65 165 55 09 30 022
16 64 140 24 07 31 095
17 78 240 40 09 38 109
18 71 163 28 07 32 014
19 68 195 24 10 36 005
20 66 122 33 09 26 170
21 53 115 25 07 25 036
22 71 210 30 10 36 050
23 78 108 23 07 22 075
24 69 126 23 08 24 175
25 77 215 24 12 36 041
26 68 125 23 08 30 036
27 62 105 50 06 24 235
28 69 126 42 09 27 130
29 55 140 42 08 29 014
30 67 145 30 08 30 050
In: Statistics and Probability
As part of the quarterly reviews, the manager of a retail store analyzes the quality of customer service based on the periodic customer satisfaction ratings (on a scale of 1 to 10 with 1 = Poor and 10 = Excellent). To understand the level of service quality, which includes the waiting times of the customers in the checkout section, he collected data on 100 customers who visited the store; see the attached Excel file: ServiceQuality.
Using XLMiner Platform > Cluster, apply K-Means Clustering with the following Selected Variables: Wait Time (min), Purchase Amount ($), Customer Age, and Customer Satisfaction Rating as Selected Variables. In Step 2 of the XLMiner k-Means Clustering procedure, normalize input data, assume k = 5 clusters, 50 iterations, and fixed start with the default Centroid Initialization seed of 12345. (Note: If the allowable number of iterations is less than 50, it means that you do not use the educational version of XLMiner available to BUAD 2070 students; see the syllabus.)
1. A) What is the minimum normalized (standardized) Euclidean distance between created cluster centers (centroids)?
B) What is the maximum average normalized Euclidean distance between the cluster observations and the cluster centroid?
C) Based on your answers to Questions 1a and 1b, are the five created clusters justifiable? (Note. Recall that the distances between clusters should be greater than the distances within clusters.)
D) Using original data (coordinates), what are the maximum and the minimum average customer satisfaction ratings for the five created clusters?
E) Using original data (coordinates), what are the maximum and the minimum average wait times (in minutes) for the five created clusters?
F) Using original data (coordinates), what are the maximum and the minimum average purchase amounts ($) for the five created clusters?
G) Based on your answers to Questions 1d, 1e, and 1f, what reasons do you see for low customer satisfaction ratings?
2. Using XLMiner Platform > Cluster, apply Hierarchical Clustering with the following Selected Variables: Wait Time (min), Purchase Amount ($), Customer Age, and Customer Satisfaction Rating. In Steps 2 and 3 of the XLMiner Hierarchical Clustering procedure, normalize input data and apply Ward’s clustering method with k = 5 clusters.
A) What is thee obtained dendrogram?
B) For each of the five created clusters, find the number of observations and the averages for the four variables. Hint: Using the worksheet HC_Clusters, you may first sort the column Cluster ID, and next calculate these numbers (using e.g. Excel function COUNTIF) and these averages (using Excel function AVERAGE).
C) Based on your findings for Task 2b, what reasons do you see for low customer satisfaction ratings?
D) Provide some recommendations for improving customer satisfaction.
Write a managerial report in MS Word that presents your findings. Do not attach any separate XLMiner and/or Excel outputs. Instead paste into your report the XLMiner outputs with answers to Questions 1a, 1b, 1d, 1e, and 2a, and Excel results related to Task 2b. Showing these outputs/results is crucial because without them I will not be able to verify your findings.
| Customer Number | Wait Time (min) | Purchase Amount ($) | Customer Age | Customer Satisfaction Rating |
| 1 | 2.3 | 436 | 42 | 7 |
| 2 | 2.8 | 408 | 33 | 6 |
| 3 | 3.2 | 432 | 38 | 5 |
| 4 | 3.4 | 431 | 40 | 5 |
| 5 | 3.4 | 456 | 29 | 6 |
| 6 | 4.2 | 537 | 46 | 4 |
| 7 | 3.2 | 456 | 42 | 5 |
| 8 | 1.4 | 430 | 40 | 8 |
| 9 | 6.4 | 663 | 24 | 3 |
| 10 | 7.8 | 839 | 37 | 4 |
| 11 | 6.5 | 659 | 52 | 5 |
| 12 | 9.8 | 836 | 43 | 2 |
| 13 | 5 | 543 | 56 | 4 |
| 14 | 1.8 | 419 | 35 | 8 |
| 15 | 6.1 | 700 | 39 | 6 |
| 16 | 3.4 | 432 | 44 | 7 |
| 17 | 7.8 | 845 | 33 | 5 |
| 18 | 2.8 | 467 | 42 | 6 |
| 19 | 1.2 | 425 | 46 | 8 |
| 20 | 9.5 | 848 | 50 | 4 |
| 21 | 8.2 | 808 | 55 | 3 |
| 22 | 7.6 | 674 | 35 | 3 |
| 23 | 5.4 | 547 | 52 | 4 |
| 24 | 6.7 | 691 | 38 | 5 |
| 25 | 9.6 | 847 | 53 | 4 |
| 26 | 11.4 | 826 | 48 | 2 |
| 27 | 2.1 | 426 | 52 | 7 |
| 28 | 5.6 | 535 | 32 | 7 |
| 29 | 3.7 | 521 | 43 | 8 |
| 30 | 4.9 | 513 | 44 | 6 |
| 31 | 6.4 | 645 | 53 | 5 |
| 32 | 9.3 | 846 | 52 | 4 |
| 33 | 10.6 | 730 | 51 | 3 |
| 34 | 6.5 | 786 | 53 | 3 |
| 35 | 5.4 | 523 | 46 | 5 |
| 36 | 7.6 | 654 | 36 | 6 |
| 37 | 3.2 | 443 | 48 | 7 |
| 38 | 2.4 | 409 | 54 | 8 |
| 39 | 1 | 400 | 39 | 6 |
| 40 | 0.2 | 418 | 51 | 7 |
| 41 | 2.4 | 498 | 30 | 6 |
| 42 | 5.7 | 532 | 32 | 5 |
| 43 | 6.4 | 663 | 44 | 7 |
| 44 | 6 | 681 | 39 | 8 |
| 45 | 3.7 | 543 | 54 | 5 |
| 46 | 8.7 | 800 | 51 | 5 |
| 47 | 6.9 | 673 | 45 | 5 |
| 48 | 9.8 | 856 | 43 | 4 |
| 49 | 10 | 756 | 44 | 4 |
| 50 | 9.5 | 854 | 43 | 6 |
| 51 | 6.3 | 672 | 50 | 6 |
| 52 | 7.4 | 698 | 47 | 7 |
| 53 | 2.3 | 434 | 43 | 7 |
| 54 | 4.6 | 544 | 40 | 4 |
| 55 | 4.9 | 523 | 53 | 6 |
| 56 | 5.7 | 546 | 55 | 6 |
| 57 | 7.4 | 676 | 42 | 8 |
| 58 | 6.8 | 662 | 36 | 6 |
| 59 | 9.6 | 1000 | 40 | 5 |
| 60 | 6.4 | 678 | 46 | 5 |
| 61 | 7.2 | 655 | 32 | 4 |
| 62 | 5.6 | 535 | 36 | 5 |
| 63 | 9.7 | 833 | 35 | 3 |
| 64 | 2.3 | 498 | 30 | 7 |
| 65 | 4.3 | 508 | 41 | 6 |
| 66 | 5.7 | 542 | 49 | 6 |
| 67 | 2.4 | 435 | 39 | 8 |
| 68 | 6.7 | 665 | 41 | 5 |
| 69 | 2.4 | 387 | 54 | 9 |
| 70 | 9.8 | 845 | 34 | 7 |
| 71 | 4.5 | 532 | 40 | 6 |
| 72 | 6.7 | 687 | 30 | 5 |
| 73 | 7.2 | 643 | 33 | 4 |
| 74 | 3.5 | 424 | 49 | 7 |
| 75 | 8.9 | 836 | 47 | 5 |
| 76 | 9.7 | 876 | 31 | 4 |
| 77 | 3.5 | 456 | 47 | 7 |
| 78 | 4.7 | 523 | 49 | 6 |
| 79 | 8.5 | 818 | 35 | 5 |
| 80 | 9.7 | 845 | 54 | 4 |
| 81 | 2.7 | 401 | 55 | 7 |
| 82 | 5.7 | 554 | 43 | 6 |
| 83 | 7.6 | 648 | 51 | 7 |
| 84 | 4.4 | 540 | 31 | 6 |
| 85 | 7.8 | 839 | 45 | 5 |
| 86 | 9.4 | 845 | 48 | 4 |
| 87 | 4.9 | 534 | 36 | 5 |
| 88 | 7.1 | 693 | 44 | 4 |
| 89 | 5.4 | 512 | 39 | 3 |
| 90 | 6.7 | 665 | 49 | 5 |
| 91 | 8.6 | 825 | 36 | 5 |
| 92 | 4.5 | 548 | 30 | 7 |
| 93 | 6.1 | 704 | 31 | 5 |
| 94 | 5.3 | 509 | 31 | 6 |
| 95 | 6.7 | 672 | 35 | 5 |
| 96 | 8.1 | 824 | 36 | 4 |
| 97 | 6.3 | 632 | 30 | 4 |
| 98 | 7.4 | 689 | 35 | 2 |
| 99 | 8.8 | 839 | 50 | 4 |
| 100 | 9.6 | 847 | 35 | 2 |
In: Statistics and Probability
Appendix Four:
Region
Supporter North East South West Midwest
1 23 36 45 22 40
2 66 50 48 51 75
3 43 40 29 52 65
4 70 28 30 31 30
5 60 26 38 35 67
6 49 34 87 65 78
7 54 59 20 19 67
8 64 51 26 29 76
9 54 50 39 43 44
10 60 42 38 54 61
11 70 58 50 48 70
12 49 48 29 18 90
13 38 37 21 34 78
14 40 31 29 30 69
15 49 52 40 50 28
In: Math
Do private practice doctors and hospital doctors have the same distribution of working hours? Suppose that a sample of 100 private practice doctors and 150 hospital doctors are selected at random and asked about the number of hours a week they work. The results are shown in the table below.
| 20–30 | 30–40 | 40–50 | 50–60 | |
|---|---|---|---|---|
| Private Practice | 16 | 40 | 38 | 6 |
| Hospital | 8 | 44 | 59 | 39 |
A. State the null and alternative hypotheses.
B. What is the test statistic? (Round your answer to two decimal places.)
C. What can you conclude at the 5% significance level? (from the following- We reject the null hypothesis. There is enough evidence to show that the distribution of working hours for private practice doctors is not the same as the distribution of working hours for hospital doctors. ---We fail to reject the null hypothesis. There is enough evidence to show that the number of hours worked is dependent on the type of doctor. ---- We fail to reject the null hypothesis. There is not enough evidence to show that the distribution of working hours for private practice doctors is not the same as the distribution of working hours for hospital doctors.----We fail to reject the null hypothesis. There is not enough evidence to show that the number of hours worked is dependent on the type of doctor. ---- We reject the null hypothesis. There is not enough evidence to show that the distribution of working hours for private practice doctors is not the same as the distribution of working hours for hospital doctors.)
In: Statistics and Probability
The city of Gadsden, Alabama (where Noah’s parents live) is considering replacing one of the bridges that cross the Coosa River that runs through town. The primary benefits of replacing the current bridge are reductions in commute time, traffic, and better foot traffic safety for people walking across the bridge. The expected cost of the bridge is $8 million. The expected benefits from primary sources over the coming years are $4 million immediately, and $1 million each year over the next 4 years. Discuss the cost-benefit analysis associated with this project. Is it possible to improve the cost-benefit analysis? Is anything missing from it?. Should the city go forward with the project? Why or why not?
In: Economics
Two four-sided dice are tossed and summed 50 times. The resulting frequencies of the sums are given below:
Value 2 3 4 5 6 7 8
Frequency 2 7 12 14 7 3 4
Compute the chi-squared statistic assuming both dice are fair.
In: Statistics and Probability
Albatross Airline’s fixed operating costs are $5 million, and its variable cost ratio is 0.30. The firm has $1.3 million in bonds outstanding with a coupon interest rate of 7 percent. Albatross has 25,000 shares of preferred stock outstanding, which pays a $3 annual dividend. There are 70,000 shares of common stock outstanding. Revenues for the firm are $8 million, and the firm is in the 40 percent corporate income tax bracket. Compute the following for the firm. Round your answers to two decimal places.
Degree of operating leverage:
Degree of financial leverage:
Degree of combined leverage:
Interpret this value for DCL. A 1% change in_______ will result in a ________% change in ________________
Enter the word sales, ebit, or EPS in the first and last blanks.Round to two decimal places for the change
In: Finance
1. [Normal Form Game] Consider the following game on advertising and price strategy between two local businesses (P is price and A is advertising). Payoffs are representative of profits. Find the Nash equilibrium. If there was collusion between the two businesses, could they cooperate and improve their profits?
|
Sarah’s Sandwiches |
|||||
|
Bandit’s Bagels |
Low P, Low A |
Low P, High A |
High P, Low A |
High P, High A |
|
|
Low P, Low A |
30, 20 |
20, 25 |
35, 15 |
30, 30 |
|
|
Low P, High A |
35, 15 |
40, 30 |
45, 8 |
40, 25 |
|
|
High P, Low A |
25, 25 |
25, 35 |
53, 47 |
25, 50 |
|
|
High P, High A |
30, 20 |
40, 30 |
55, 20 |
50, 45 |
|
In: Economics
Write a C++ program to play the dice game "Craps". Craps is one of the most popular games of chance and is played in casinos and back alleys throughout the world. The rules of the game are straightforward:
A player rolls two dice. Each die has six faces. These faces contain 1, 2, 3, 4, 5, and 6 spots. After the dice have come to rest, the sum of the spots on the two upward faces is calculated. If the sum is 7 or 11 on the first throw, the player wins. If the sum is 2, 3, or 12 on the first throw (called "craps"), the player loses (i.e. the "house" wins). If the sum is 4, 5, 6, 8, 9, or 10 on the first throw, then the sum becomes the player's "point." To win, you must continue rolling the dice until you "make your point." The player loses by rolling a 7 before making the point.
At a minimum, your solution must contain the functions below.
void displayGameRules()
int rollOneDice()
int rollTwoDice()
Write a program that implements craps according to the above rules. Additionally:
In: Computer Science
Calcium chloride, CaCl2, is an ionic compound in which? Question 37 options: ?each chlorine atom has lost electrons. ?one chlorine atom transferred an electron to the other chlorine atom. ?calcium has two extra electrons in its innermost shell. ?calcium has lost two electrons. ?calcium has gained two electrons. Save Question 38 (1 point)
A covalent bond is? Question 38 options: ?a sharing of protons between two atoms. ?the transfer of electrons from one atom to another. ?a type of bond that results in ionic compounds. ?an attraction of charged atoms. ?a sharing of electrons between two atoms. Save
In: Biology