- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

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

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...

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

- In a drug experiment, a reaction time measure was obtained from each participant before the administration of the drug 1 1 PS115–4–FY 1 PS115–4–FY There are 57 marks available. The marks available for...SolvedMay 17, 2022
- Statistics and Analytics for Decision Making Q.1 (30 marks) A researcher is examining the relationship between cinema occupancy levels in a large city and a number of possible explanatory variables....SolvedMay 07, 2022
- 1) A school has 1500 students and they are going to vote as to whether they will completely convert the school completely off fossil fuels. How many students would you have to poll to be 95% confident...SolvedMay 01, 2022
- You work for an automobile insurance company. Your boss has assigned you the task of reviewing recent auto safety records and thinking about how that information may be relevant to your company. You...SolvedApr 29, 2022
- Final Project</o:p> ECON 3050 (Quantitative Methods) – Spring 2022</o:p> Directions (Read VERY CAREFULLY)</o:p> 1. The final project must be properly typed and submitted through the...SolvedApr 29, 2022
- Part A: Description of Business Context Write a brief summary of the business context (e.g., manufacturing, marketing, finance, etc.) including the name of the company or organization. Wish is an...SolvedApr 29, 2022
- Assignment 6 Scope and Methods Logistic Regression Public employee retention has always been a topic of interest for government agency human resource managers. Agencies that have a high turnover rate...SolvedApr 28, 2022
- the files are attached it statistics maths, the last file is a PDF file which could be opened as normal but in relation to the files titled "box.sav" and "styles.sav" they would...SolvedApr 28, 2022
- Assignment 6 Scope and Methods Summer Semester In this question, you are interested to know various factors (income, poverty, and crime) influence whether a state adopted a policy (policy). Policy is...SolvedApr 23, 2022
- Homework 5 Scope and Methods Linear Regression 1) Input the following data into SPSS: X (Average job satisfaction) Y (Job Turnover Rate XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX194.25...SolvedApr 23, 2022

Copy and Paste Your Assignment Here

About Us | Contact Us | Help | Privacy Policy | Revision and Refund Policy | Terms & Conditions | Honor Code

Copyright © 2022. All rights reserved.