Reference no: EM131924547
Assignment
For this assignment, submit one Excel file.
Use Visit sheet to answer this question.
The vice president of marketing brought to the attention of sales managers that most of the company's manufacturer representatives contacted clients and maintained client relationships in a disorganized, haphazard way. The sales managers brought the reps in for a three-day seminar and training session on how to use an organizer to schedule visits and recall pertinent information about each client more effectively.
Sales reps were taught how to schedule visits most efficiently to maximize their efforts. Sales managers were given data on the number of site visits by sales reps on a randomly selected day both before and after the seminar.
Use the following data to test whether significantly more site visits were made after the seminar (α = .05). Assume the differences in the number of site visits are normally distributed. [Hint: Similar problem is available under Lec-6 folder]
|
REP
|
BEFORE
|
AFTER
|
|
1
|
2
|
4
|
|
2
|
4
|
5
|
|
3
|
1
|
3
|
|
4
|
3
|
3
|
|
5
|
4
|
3
|
|
6
|
2
|
5
|
|
7
|
2
|
6
|
|
8
|
3
|
4
|
|
9
|
1
|
5
|
Use Gasoline sheet to answer this question.
Suppose the data shown here are the results of a survey to investigate gasoline prices. Ten service stations were selected randomly in each of two cities and the figures represent the prices of a gallon of unleaded regular gasoline on a given day.
Use the F test to determine whether there is a significant difference in the variances of the prices of unleaded regular gasoline between these two cities. Let α = .01. Assume gasoline prices are normally distributed. [Hint: Similar problem is available under Lec-6 folder]
|
CITY 1
|
CITY 2
|
|
3.43
|
3.32
|
3.38
|
3.33
|
3.30
|
3.44
|
|
3.40
|
3.39
|
3.38
|
3.42
|
3.46
|
3.37
|
|
3.39
|
3.38
|
3.28
|
3.39
|
3.39
|
3.38
|
|
|
3.34
|
|
|
3.36
|
|
Use Part-3 sheet to answer this question.
There are several methods used by people to organize their lives in terms of keeping track of appointments, meetings, and deadlines. Some of these include using a desk calendar, using informal notes of scrap paper, keeping them "in your head," using a day planner, and keeping a formal "to do" list.
Suppose a business researcher wants to test the hypothesis that a greater proportion of marketing managers keep track of such obligations "in their head" than do accountants.
To test this, a business researcher samples 400 marketing managers and 450 accountants. Of those sampled, 220 marketing managers keep track "in their head" while 216 of the accountants do so.
Using a 1% level of significance, what does the business researcher find? Find p-value. [Hint: Similar problem is available under Lec-6 folder]
Attachment:- Dataset.rar