## [answered] MGMT 650 Fall 2016 Problem Set 5 (Last updated 9/15/2016) 1

Hello,

I need help answering questions 3 and 4 in excel with the appropriate formulas in the cells.
MGMT 650 Fall 2016 Problem Set 5

(Last updated 9/15/2016)

1. ANOVA:

UMUC wants to use a new tutorial to teach the students

randomly selected 15 students and randomly assigned them

to one of three groups which include either a PowerPoint

presentation created by the faculty, AuthorGen Presentation

created by the faculty, or a well known tutorial by the ABC

company. After completing their assigned tutorial, the

students are given a Business Ethics test. At the .01

significance level, can UMUC conclude that there is a

difference between how well the different tutorials work for

the students?

Note: (Here is a good website where you can find the f table

for significance level .01

http://www.socr.ucla.edu/Applets.dir/F_Table.html#FTable0.0

1)

PowerPoin

t Tutorial

(X1)

68

85

91

87

88 AuthorGen ABC

Tutorial

Tutorial

(X2)

(X3)

79

75

86

83

82

78

92

86

91

81 2. Pivot Table

ASPCA wanted to find out if there was a relationship between

the type of animals preferred and the gender of the owner.

They gathered data from 50 randomly chosen pet owners

who owned either one cat or one dog:

gender

female

male

male

male

female

female

female

female

male

female

female

male

male

male

female

female

female

female

female

male

male

male

male

male

female type

cat

dog

dog

dog

cat

cat

dog

cat

dog

dog

dog

dog

cat

cat

dog

cat

cat

cat

dog

cat

dog

cat

dog

dog

dog gender

male

female

male

female

female

female

male

male

male

male

male

female

female

male

female

female

male

female

male

female

male

female

male

male

male type

cat

cat

cat

dog

cat

dog

cat

dog

dog

dog

cat

dog

cat

dog

cat

cat

cat

cat

dog

dog

cat

dog

cat

cat

dog Use Excel?s capabilities to create a pivot table that shows the

number of pets owned by each gender.

3. Chi Square:

Use the pivot table from problem 1 to find the Chi Square

value and give the interpretation based on a .01 significance level. Is there are relationship between the sex of the owner

and the type of pet they prefer?

Here is a website with a chi square table:

http://sites.stat.psu.edu/~mga/401/tables/Chi-squaretable.pdf

4. Chi Square:

A human resources director wants to find out if there is a

relationship with the day of the week and the number of

times employees were sick on that day. She tallied the

number of times 60 employees were absent on these days:

Monday: 12

Tuesday: 9

Wednesday: 11

Thursday: 10

Friday: 9

Saturday: 9

Using a significance level of .05 and the Excel function,

=chiinv(), find the critical value.

a)

b)

c) What is the chi square value for this scenario?

Use the answer to b and the =chidist() equation in

Excel to find the p value.

Is there a relationship between the days of the week

and the number of employees who are sick on that

day? 5. Regression analysis:

A CEO of a large pharmaceutical company would like to

determine if he should be placing more money allotted in the

budget next year for television advertising of a new drug

marketed for controlling asthma. He wonders whether there

is a strong relationship between the amount of money spent

on television advertising for this new drug called XBC and the number of orders received. The manufacturing process

of this drug is very difficult and requires stability so the CEO

would prefer to generate a stable number of orders. The cost

of advertising is always an important consideration in the

phase I roll-out of a new drug. Data that have been collected

over the past 20 months indicate the amount of money

spent of television advertising and the number of orders

The use of linear regression is a critical tool for a manager?s

below and try to answer the questions in terms of the

problem context. Here are the results of the data collection. Mont

g cost (in

thousands

) 1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20 \$68.93

72.62

79.58

58.67

69.18

70.14

83.37

68.88

82.99

75.23

81.38

52.9

61.27

79.19

80.03

78.21

83.77

62.53

88.76

72.64 # of

orders 4,902,000

3,893,000

5,299,000

4,130,000

4,367,000

5,111,000

3,923,000

4,935,000

5,276,000

4,654,000

4,598,000

2,967,000

3,999,000

4,345,000

4,934,000

4,653,000

5,625,000

3,978,000

4,999,000

5,834,000 a) Set up a scatter diagram and calculate the associated

correlation coefficient. Discuss how strong you think the

relationship is between the amount of money spent on

Please use the Scatterplot and Correlation procedures

within Excel under Tools &gt; Data Analysis

b) What is the regression equation?

c) Interpret the meaning of the slope, b1, in the regression.

d) Predict the monthly advertising cost when the # of

orders is 5,100,000.

e) Compute the coefficient of determination, r2, and

interpret its meaning.

f) Compute the standard error of estimate, and interpret its

meaning.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001013802.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor