PHStat2 is included Free on our Student CD's that accompany a variety of our Business Statistics titles. When installed, PHStat2 attaches itself to the Excel menu bar, providing users with a pull-down menu of topics that supplement the Data Analysis Add-in Tools already included in Microsoft Excel. Access Code packaged with your textbook: Click the Register for PHStat button below. PHStat provides a software assist to help you create Excel worksheet.
![Excel Excel](/uploads/1/2/5/8/125860962/571230640.jpg)
Please solve these problems by using Excel's add-in called PhStat. What this means is that if you have the add-in, you use it (in excel) for the calculations and then cut n paste them into word.
If you DON'T have it, you can download and install it from here: http://www.sunflowerlabs.com/phstat
If you have trouble installing, you can go here:
http://www.prenhall.com/phstat/phstat2/setup(ver2).html
http://www.prenhall.com/phstat/
http://www.prenhall.com/phstat/phstat2/setup(ver2).html
http://www.prenhall.com/phstat/
After you paste the calculations into word, please answer the remaining questions. Let me know if this is still unclear.
© BrainMass Inc. brainmass.com March 21, 2019, 10:01 am ad1c9bdddfhttps://brainmass.com/statistics/hypothesis-testing/phstat-3569
Attachments
The solution addresses the following in PhStat:
Question 1
The personnel manager of a large insurance company would like to evaluate the effectiveness of four different sales training programs. Eight new recruits are assigned to each of the four training programs A to D. The scores of the members in each group on an exam are recorded below. In answering the questions below you must support your answers with specific numerical output from the Excel analysis.
A B C D
66 72 61 63
74 51 60 61
82 59 57 76
75 62 60 84
73 74 81 58
97 64 55 65
87 78 70 69
78 63 71 80
66 72 61 63
74 51 60 61
82 59 57 76
75 62 60 84
73 74 81 58
97 64 55 65
87 78 70 69
78 63 71 80
a) Is there a significant difference between the four groups?
b) Which individual groups differ from each other?
c) What is the within groups variance and why is it part of the calculations?
b) Which individual groups differ from each other?
c) What is the within groups variance and why is it part of the calculations?
Question 2
An industrial psychologist wishes to study the effects of motivation on sales in a particular firm. Of 24 new salespersons, 12 are paid an hourly rate and 12 are paid a commission. The 24 individuals are randomly assigned to two groups. The following data represent the sales volume (in thousands of dollars) achieved during the first month on the job.
a) Using a 0.05 level of significance is there evidence of a significant difference in the two groups.
b) Explain what would happen to the findings if the variance of both groups were much larger. Hint: Consult the formula for computing the t or z value in a difference of means test. You could rerun the analysis and compare outputs to answer this question.
b) Explain what would happen to the findings if the variance of both groups were much larger. Hint: Consult the formula for computing the t or z value in a difference of means test. You could rerun the analysis and compare outputs to answer this question.
Hourly Commission
256 224
212 261
239 254
216 228
222 273
236 234
207 285
219 225
228 237
225 232
241 277
230 245
256 224
212 261
239 254
216 228
222 273
236 234
207 285
219 225
228 237
225 232
241 277
230 245
Question 3
As you know from your marketing studies brand awareness is a key consideration in promotion. An advertising manager wants to know whether the campaign the company is currently running is achieving an average awareness score of 80 or above. He distributes 50 questionnaires to potential buyers. The questionnaire measures brand awareness on a 0-100 scale. The mean score is 82.3 with a standard deviation of 14.1.
![Where is phstat in excel formula Where is phstat in excel formula](/uploads/1/2/5/8/125860962/820289994.jpg)
a) Set up the null and alternative hypotheses.
b) Determine at the 0.05 level of significance whether the advertising manager has achieved his brand awareness objective.
c) Rerun the analysis in part b but with a sample size of 150. If the conclusion drawn from the analysis is different you must explain why. Hint look at the formula for z or t in a test of a single mean and/or compare your two outputs very carefully.
b) Determine at the 0.05 level of significance whether the advertising manager has achieved his brand awareness objective.
c) Rerun the analysis in part b but with a sample size of 150. If the conclusion drawn from the analysis is different you must explain why. Hint look at the formula for z or t in a test of a single mean and/or compare your two outputs very carefully.
- Subject Catalog
- Humanities & Social Sciences
- Communication, Film & Theatre Catalog
- English
- Interdisciplinary Studies
- World Languages
- Math & Science
- Biology & Microbiology
- Mathematics
- Statistics
- Professional & Career
- Business
- Culinary, Hospitality, Travel & Tourism
- Education
- EMS & Fire Science (BRADY)
- Engineering
- Fashion & Interior Design
- Health Professions
- Information Technology
- Nursing
- Trades & Technology
- Sign in to download instructor resources
- Humanities & Social Sciences
- Products & Services for Teaching
- Digital Learning Environments
- Nursing Concepts Curriculum
- Course Content
- Textbooks & eTextbooks
- Pearson eText
- Textbooks & eTextbooks
- Distance Learning Solutions
- CourseConnect
- Support
- NCCERconnect
- Support
- Propero
- For Students
- For Educators & Institutions
- Success Stories
- Support
- CourseConnect
- Learning & Engagement Tools
- Duolingo
- Learning Catalytics
- User Stories
- Training & Support
- For Educators
- For Students
- Pearson Writer
- Is Pearson Writer for Me?
- Training & Support
- StatCrunch
- Strategic Reader
- Test Prep & Testing Solutions
- English Language Teaching
- Digital Learning Environments
- Products & Services for Institutions
- Credit for Prior Learning
- Curriculum Services
- Digital Credentials
- Grant Help
- Finding Grant Funding
- MyLabsPlus
- Online Program Management
- Our Services
- Customers
- Educators
- Institutional Leaders
- Students
- Get involved
- How to become a blogger
- Get involved
- Community Colleges
- College Resellers
- Why Choose Pearson?
- Thought Leadership
- Acceleration, Redesign & Readiness
- Resources for Getting Started
- Solutions for Math
- Solutions for English
- Career Readiness & Employability
- College Readiness & Completion
- Transition to College (K–12)
- Solutions for Math
- Dual Enrollment Programs
- Transition to College (K–12)
- Online & Blended Learning
- Online Learning Services
- Digital Learning
- Acceleration, Redesign & Readiness
- Thought Leadership