Instructions 1. The submission must be typed in a Microsoft WORD document and NOT handwritten. 2. Upload BOTH the Excel (working) file as well as the final Word/PDF file 4. DO NOT VIOLATE the honor...

1 answer below »

Instructions
1. The submission must be typed in a Microsoft WORD document and NOT handwritten.
2. Upload BOTH the Excel (working) file as well as the final Word/PDF file
4. DO NOT VIOLATE the honor code. Your submission MUST BE your OWN work.
5. Early submission is welcome and strongly encouraged.
Part I
Imagine that you are the CEO of a company that sells construction equipment and building materials
all over the country. The operations of the company are divided in 4 regions. Each region is headed
y a regional VP. Each region is divided in multiple te
itories. Each te
itory has its own sales team.
Each region has 30 or more sales teams. Each te
itorial sales team is headed by a sales manager. All
sales managers report to the co
esponding regional VP. All regional VPs report directly to you.
The numbers in the table below represent a sample of net incomes (in millions of US Dollars)
generated by the individual te
itorial sales teams during the last quarter.
Region A XXXXXXXXXXRegion B XXXXXXXXXXRegion C Region D
13.96 XXXXXXXXXX1 XXXXXXXXXX XXXXXXXXXX.54
16.07 XXXXXXXXXX3 XXXXXXXXXX XXXXXXXXXX.86
7.82 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX39.13
16.58 XXXXXXXXXX0. XXXXXXXXXX0 XXXXXXXXXX2.17
7.93 XXXXXXXXXX16 XXXXXXXXXX XXXXXXXXXX10.37
4.41 XXXXXXXXXX15. XXXXXXXXXX7 XXXXXXXXXX2.17
XXXXXXXXXX22.47 XXXXXXXXXX15.94
XXXXXXXXXX13.04
Regional VPs enjoy significant autonomy. They can choose their own sales managers and sales
managers can choose their own team members. As a CEO you want to compare between the regions
and figure out as to which region is doing better than the others.
With this background, answer the following questions:
1. Find the 95% confidence interval of team sales in Region A.
2. Find the 95% confidence interval of team sales in Region B.
3. Find the 95% confidence interval of team sales in Region C.
4. Find the 95% confidence interval of team sales in Region D.
5. Find the 95% confidence interval of the difference of team sales between Regions A and B.
6. Find the 95% confidence interval of the difference of team sales between Regions A and C.
7. Find the 95% confidence interval of the difference of team sales between Regions A and D.
8. Find the 95% confidence interval of the difference of team sales between Regions B and C.
9. Find the 95% confidence interval of the difference of team sales between Regions B and D.
10. Find the 95% confidence interval of the difference of team sales between Regions C and D.
11. Test the hypothesis that the average team sales are equal between Regions A and B.
12. Test the hypothesis that the average team sales are equal between Regions A and C.
13. Test the hypothesis that the average team sales are equal between Regions A and D.
14. Test the hypothesis that the average team sales are equal between Regions B and C.
15. Test the hypothesis that the average team sales are equal between Regions B and D.
16. Test the hypothesis that the average team sales are equal between Regions C and D
17. Test the hypothesis that the variances of team sales are equal between Regions A and B.
18. Test the hypothesis that the variances of team sales are equal between Regions A and C.
19. Test the hypothesis that the variances of team sales are equal between Regions A and D.
20. Test the hypothesis that the variances of team sales are equal between Regions B and C.
21. Test the hypothesis that the variances of team sales are equal between Regions B and D.
22. Test the hypothesis that the variances of team sales are equal between Regions C and D.
23. Regional VPs always claim that there is no statistical difference between team sales between
egions. Perform an analysis to test their claim.
24. Given the answers to the questions above, what conclusion would you draw as a CEO regarding
the performance of various sales teams in different regions. What message would you have fo
the (a) regionals VPs, (b) the Board, (c) company shareholders? Carefully prepare an executive
eport of no more than 4-5 pages summarizing your observations backed by data and statistical
analysis. Please note that this report should be intelligible to a general audience member who
may not have a good background in statistics and quantitative methods.
For all questions above, assume that Probability of Type I E
or α 0.05
Part II
The attached file state-health.xlsx contains data on all US states for the following variables:
1. medinc: Median Annual Household Income
2. stax: State Collections of all taxes per Capita
3. leab: Life Expectancy at Birth (years)
4. phys: Number of physicians per 100,000 population
5. uins: Percentage of population who are uninsured
The data is collected from the https:
www.kff.org/statedata/ on November 1, 2021.
Using the data estimate the following regression models and carefully explain all the results.
a. leab 0 0 (medinc )
. ln(leab) 0 1 [ln(medinc)]
c. leab=0 1 (medinc ) 2 (medinc2 )
d. leab 0 1 (medinc ) 2(medinc XXXXXXXXXXphys)
e. leab 0 1 (medinc ) 2(medinc XXXXXXXXXXphys) +4(uins)
f. leab 0 1 (medinc ) 2(medinc XXXXXXXXXXphys) +4(uins) 5 (stax )
g. stax= 0 1 [ln(medinc)]
h. In(stax) 0 1 [ln(medinc)]
Augment the data by introducing a new column that contains the regional designation for a state.
The designations may be found athttps:
www2.census.gov/geo/pdfs/maps-data/maps
eference/us_regdiv.pdf
Perform appropriate ANOVA to test the following
a) Average per capita state tax collection is the same in all census regions.
b) Average life expectancy is the same in all census regions.
c) Average number of physicians per 100,000 population is the same in all census regions.
d) Average percentage of population who are uninsured is the same in all census regions.
Write an essay (no more than two pages) analyzing health disparities (as the differences in life
expectancies at birth) and their drivers across various states and regions in the USA.
Answered Same DayApr 14, 2022

Solution

Bikash answered on Apr 14 2022
11 Votes
1. Find the 95% confidence interval of team sales in Region A.
    Lower Interval
    5.808833547
    Upper Interval
    16.44783312
2. Find the 95% confidence interval of team sales in Region B.
    Lower Interval
    8.37651523
    Upper Interval
    27.68634191
3. Find the 95% confidence interval of team sales in Region C.
    Lower Interval
    1.985424322
    Upper Interval
    25.74790901
4. Find the 95% confidence interval of team sales in Region D.
    Lower Interval
    1.804419516
    Upper Interval
    22.00058048
5. Find the 95% confidence interval of the difference of team sales between Regions A and B.
    Lowe
    -17.2301
    Uppe
    3.42388
6. Find the 95% confidence interval of the difference of team sales between Regions A and C.
    Lowe
    -14.0219
    Uppe
    8.54522
7. Find the 95% confidence interval of the difference of team sales between Regions A and D.
    Lowe
    -11.3477
    Uppe
    9.79936
8. Find the 95% confidence interval of the difference of team sales between Regions B and C.
    Lowe
    -9.12039
    Uppe
    17.44992
9. Find the 95% confidence interval of the difference of team sales between Regions B and D.
    Lowe
    -6.56328
    Uppe
    18.82113
10. Find the 95% confidence interval of the difference of team sales between Regions C and D.
    Lowe
    -11.8845
    Uppe
    15.81287
11. Test the hypothesis that the average team sales are equal between Regions A and B.
    t-Test: Two-Sample Assuming Equal Variances
    
    
    
    
    
     
    Region A
    Region B
    Mean
    11.12833333
    18.03142857
    Variance
    25.69389667
    108.9828476
    Observations
    6
    7
    Pooled Variance
    71.12423355
     
    Hypothesized Mean Difference
    0
     
    df
    11
     
    t Stat
    -1.47125528
     
    P(T<=t) one-tail
    0.084621345
     
    t Critical one-tail
    1.795884819
     
    P(T<=t) two-tail
    0.169242691
     
    t Critical two-tail
    2.20098516
     
Since p value is greater than 0.05, we fail to reject the null hypothesis and conclude that the average sales are equal between Regions A and B
12. Test the hypothesis that the average team sales are equal between Regions A and C.
    t-Test: Two-Sample Assuming Equal Variances
     
     
     
     
     
     
    Region A
    Region C
    Mean
    11.12833333
    13.86666667
    Variance
    25.69389667
    128.1775867
    Observations
    6
    6
    Pooled Variance
    76.93574167
     
    Hypothesized Mean Difference
    0
     
    df
    10
     
    t Stat
    -0.540732992
     
    P(T<=t) one-tail
    0.300263951
     
    t Critical one-tail
    1.812461123
     
    P(T<=t) two-tail
    0.600527903
     
    t Critical two-tail
    2.228138852
     
Since p value is greater than 0.05, we fail to reject the null hypothesis and conclude that the average sales are equal between Regions A and C.
13. Test the hypothesis that the average team sales are equal between Regions A and D.
    t-Test: Two-Sample Assuming Unequal Variances
    
    
    
    
     
    Region A
    Region D
    Mean
    11.12833333
    11.9025
    Variance
    25.69389667
    145.8959929
    Observations
    6
    8
    Hypothesized Mean Difference
    0
    
    df
    10
    
    t Stat
    -0.163138655
    
    P(T<=t) one-tail
    0.436829511
    
    t Critical one-tail
    1.812461123
    
    P(T<=t) two-tail
    0.873659023
    
    t Critical two-tail
    2.228138852
     
Since p value is greater than 0.05, we fail to reject the null hypothesis and conclude that the average sales are equal between Regions A and D.
14. Test the hypothesis that the average team sales are equal between Regions B and C.
    t-Test: Two-Sample Assuming Equal Variances
     
     
     
     
     
     
    Region B
    Region C
    Mean
    18.03142857
    13.86666667
    Variance
    108.9828476
    128.1775867
    Observations
    7
    6
    Pooled Variance
    117.707729
     
    Hypothesized Mean Difference
    0
     
    df
    11
     
    t Stat
    0.689986601
     
    P(T<=t) one-tail
    0.252249782
     
    t Critical one-tail
    1.795884819
     
    P(T<=t) two-tail
    0.504499564
     
    t Critical two-tail
    2.20098516
     
Since p value is greater than 0.05, we fail to reject the null hypothesis and conclude that the average sales are equal between Regions B and C.
15. Test the hypothesis that the average team sales are equal between Regions B and D.
    t-Test: Two-Sample Assuming Equal Variances
     
     
     
     
     
     
    Region B
    Region D
    Mean
    18.03142857
    11.9025
    Variance
    108.9828476
    145.8959929
    Observations
    7
    8
    Pooled Variance
    128.8591566
     
    Hypothesized Mean Difference
    0
     
    df
    13
     
    t Stat
    1.043218552
     
    P(T<=t) one-tail
    0.157929673
     
    t Critical one-tail
    1.770933396
     
    P(T<=t) two-tail
    0.315859347
     
    t Critical two-tail
    2.160368656
     
Since p value is greater than 0.05, we fail to reject the null hypothesis and conclude that the average sales are equal between Regions B and D.
16. Test the hypothesis that the average team sales are equal between Regions C and D
    t-Test: Two-Sample Assuming Equal Variances
     
     
     
     
     
     
    Region C
    Region D
    Mean
    13.86666667
    11.9025
    Variance
    128.1775867
    145.8959929
    Observations
    6
    8
    Pooled Variance
    138.5133236
     
    Hypothesized Mean Difference
    0
     
    df
    12
     
    t Stat
    0.309021832
     
    P(T<=t) one-tail
    0.381302215
     
    t Critical one-tail
    1.782287556
     
    P(T<=t) two-tail
    0.762604429
     
    t Critical two-tail
    2.17881283
     
Since p value is greater than 0.05, we fail to reject the null hypothesis and conclude that the average sales are equal between Regions C and D.
17. Test the hypothesis that the variances of team sales are equal between Regions A and B.
    F-Test Two-Sample for Variances
    
    
    
    
    
     
    Region B
    Region A
    Mean
    18.03142857
    11.12833333
    Variance
    108.9828476
    25.69389667
    Observations
    7
    6
    df
    6
    5
    F
    4.241585036
    
    P(F<=f) one-tail
    0.067149342
    
    F Critical one-tail
    4.950288069
     
Since F value is less than F Critical Value therefore variances are equal.
18. Test the hypothesis that the variances of team sales are equal between Regions A and C.
    F-Test Two-Sample for Variances
    
    
    
    
    
     
    Region C
    Region A
    Mean
    13.86666667
    11.12833333
    Variance
    128.1775867
    25.69389667
    Observations
    6
    6
    df
    5
    5
    F
    4.988639455
    
    P(F<=f) one-tail
    0.051192252
    
    F Critical...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here