TOM 3020 Managerial Statistics Questions 8 math questions need to be answer. Based on the study material and need to use excel. QUESTION 1 The personnel de

TOM 3020 Managerial Statistics Questions 8 math questions need to be answer. Based on the study material and need to use excel. QUESTION 1
The personnel department of a large corporation reported sixty resignations during the last year. The
following table groups these resignations according to the season in which they occurred.
Number of
Season
Winter
Spring
Summer
Fall
Resignations
10
22
19
9
Test to see if the number of resignations is the same over the four seasons. Provide the p-value from your
analysis.
Hint: When conducting a Chi-Square analysis, construct the expected and observed tables. Here the observed
table is provided to you. The expected numbers should be the same number of resignations across the time
periods (which is provided in the problem).
QUESTION 2
Among 1000 managers with degrees in business administration, the following data shows their
management level and field of study.
Major
Management
Marketing
Accounting
TOTAL
Top Management
Middle
Management
TOTAL
280
120
150
550
220
80
150
450
500
200
300
1000
We want to determine if the position in management is independent of field (major) of
concentration.
Provide the test statistic value from your analysis.
QUESTION 3
Before a campaign, a study to determine whether support for the Governor has changed.The following data
was from last year:
Support
35%
Does not support 22%
Unsure
43%
After the campaign, a random sample of 200, 38% support the candidate, 23% does not support, and 39% is
unsure. Let us suppose we would like to find whether there is evidence that the campaign has an effect on the
public’s opinion. Provide the test statistic value for this analysis.
Hint: To solve any Chi-Square hypothesis testing question, simply create an expected table and an observed
table. Here, the expected table should be calculated based on assuming there were no change in public
opinion (from the old percentages).
QUESTION 4
We are interested in studying whether education level affects people’s credit default risk (failing paying their
credit debt). A random study was conducted to see the percent of those who default on their credit card was
conducted.
HIghest level education attained % defaulted Number of people studied
High School
36%
100
Some College
20%
160
Bachelor’s degree
15%
180
Advanced degree
6%
50
Test the null hypothesis of whether the popluation proportions of credit default rate is the same for all levels
of education. Provide the test statistic value from your analysis.
QUESTION 5
A group of 2000 individuals from 3 different cities were asked whether they owned a foreign or a
domestic car. The following contingency table shows the results of the survey.
CITY
Type of Car
Domestic
Foreign
Total
Detroit
80
120
200
Atlanta
200
600
800
Denver
520
480
1000
Total
800
1200
2000
At α = 0.05 using the p-value approach, test to determine if the type of car purchased is
independent of the city in which the purchasers live.
Provide the test statistic value from your analysis.
QUESTION 6
Kate Sanders, a researcher in the department of biology at IPFW University, studied the effect of agriculture
contaminants on the stream fish population in Northeastern Indiana. Specially designed traps collected
samples of fish at each of four stream locations. The research question was, “Did the differences in
agricultural contaminants found at the four locations alter the proportion of the fish population by gender?”
Observed frequencies were as follows:
A B C D
Male
49 44 49 39
Female 32 46 36 44
To solve this type of chi-square testing for equality of multiple proportions, we would need to create an
expected table. Provide the value for the ??? box.
A
Male
B C D
???
Female
Note: as always, keep four decimal places when entering in your responses.
QUESTION 7
The Wall Street Journal Corporate Perceptions Study 2011 surveyed readers and asked how each rated the
quality of management and the reputation of the company for over 250 worldwide corporations. Quality of
management is rated on a scale of exceptional, moderate, andneeds improvement categorical scale. And
company reputation is rated on a scale of excellent, good, and fair categorical scale. Assume the sample data
for the respondents are below:
Excellent Good Fair
Exceptional
40
25
5
Moderate
35
44
10
Needs Improvement
25
10
15
To conduct a Chi-Square testing to analyze the independence of two variables, we must construct an expected
frequency table. Provide the value that would go into the box with the ???
Excellent Good Fair
Exceptional
Moderate
Needs Improvement
??
Note: as always, enter your response in 4 decimal places.
QUESTION 8
Business travelers stay in a variety of accommodations. A set of previous year’s national percentages for
types of accommodations shows their choices below. During a sluggish economy there may be changes in
business traveler accommodation patterns so a travel consultant surveyed the business travelers and asked
about their accommodations. These data will be used to test whether or not the present accommodation
distribution is the same as the national one.
National Percentage Present Accommodation
Home or Motel
64
186
Cabin, Condo or Vacation Home
17
43
Stayed with Friends/Relatives
14
57
Other
5
12
In solving this problem, an expected frequency table must be created. Provide the value that would go into
the ??? box.
Hotel or Motel
???
Cabin, Condo, or Vacation Home
Stayed with Friends/Relatives
Other
Note: as always, enter your answer with 4 decimal places.

Purchase answer to see full
attachment

Don't use plagiarized sources. Get Your Custom Essay on
TOM 3020 Managerial Statistics Questions 8 math questions need to be answer. Based on the study material and need to use excel. QUESTION 1 The personnel de
For $10/Page 0nly
Order Essay
Calculator

Calculate the price of your paper

Total price:$26

Need a better grade?
We've got you covered.

Order your paper