Workplace Wellness at Starfish Resorts
Part 2: Analyzing the Pilot Program Using Conditional Expectations
Continue analyzing the pilot program
(PilotDatasheet)
. Use a Pivot Table to answer the
following questions.
1.
What is the average age of people who participated in the wellness program?
2.
What is the average age of people who did not participate in the wellness
program?
3.
How big is the diDerence in health spending between those in the wellness
program and not in the program?
4.
Which of the following best captures the conclusion we can make from the pilot
program?
a.
The wellness program reduced spending
b.
The wellness program increased spending
c.
Users of the wellness program had lower spending
d.
Users of the wellness program had higher spending
Use an IF statement to create a new variable by recoding anyone over 40 as “older” and
answer the following questions.
1.
What is the probability of being older?
2.
What it is the probability of participating in the wellness program?
3.
Is there a diDerence in health spending between younger and older?
4.
What is the probability an older person choosing to participate in the wellness
program?
Is it diDerent than the probability a younger person choosing to
participate in the wellness program?
5.
Are age status (older vs. younger) and participation in the wellness program
independent?
Save your spreadsheet for future classes
