[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

 

about business ethics. As an experiment the administrator

 

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

 

received.

 

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

 

decision-making ability. Please carefully read the example

 

below and try to answer the questions in terms of the

 

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

 

h Advertisin

 

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

 

television advertising and the number of orders received.

 

Please use the Scatterplot and Correlation procedures

 

within Excel under Tools > 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:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.