Data description

The provided data file includes 3 sheets including "Data Description" and "Member Data". The "Data Description" sheet describes all the variables used in the other tw0 work sheets and copied below for your convenience.

Campaign Sheet:

Member ID:

Numbered list from Member 1 to Member 200

Member Gender:

All memberships identify a primary contact. Member Gender is the gender of each membership's primary contact:

Male

Female

Prefer Not to Say

Age:

The age of the primary member

Age Band (CAT):

All memberships are classified into for different Age Bands (based on the primary member):

Young

, primary member is less than 20 years of age

Core

, primary member is between 20and 39 years of age

Prime

, primary member is between 40 and 59 years of age

Senior, primary member is 60 years

of age or more

Years of Membership:

How many years since the membership of the Boomers commenced.

Membership Type:

Members can subscribe for one of four Membership Types:

Individual, primary member is the sole member

Couple, primary member is one of a couple

(membership covers two people)

Family, primary member is one of a family (three to six people)

Group

,

primary member is one of a group (two to twenty people)

Games Attended

:

The number of games attended by the primary member in the 2019 season

(max = 10)

Ticket Type:

Members can subscribe for one of four ticketing arrangements:

Bronze, where all patrons on the membership can sit in an unreserved seating area.

Silver

, where all patrons on the membership have reserved seats in an area with restricted views

Gold

, where all patrons on the membership have reserved seats in an area with unrestricted views

Platinum

, where all patrons on the membership have reserved seats in a premium area with at

-seat service

Ticket Revenue:

The amount of money paid by all patrons on the membership for the 2019 season

Merchandise Revenue:

The amount of money paid for Boomers merchandise by all patrons on the membership, for the 2019 season

Refreshment Revenue:

The amount of money paid for refreshments by all patrons on the membership, at all Boomers games for the 2019 season

Total Revenue:

The total of Ticket and Merchandise and Refreshment Revenue, for all patrons on each membership, for the 2019 season.

Member Satisfaction:

The satisfaction rating provided by the primary member for the 2019 season

(where 0 = completely dis-satisfised, and 100 = completely satisfied)-assumed

to reflect the collective experience of all patrons on the membership

.

Satisfaction Type (CAT):

All memberships are classified into for different Satisfaction Types:

Unhappy

, Satisfaction Rating <50

Acceptable

, Satisfaction Rating between 50 and 69

Happy

,

Satisfaction Rating between 70 and 79

Delighted, Satisfaction Rating between 80 and 100 (max)

Across the entire sample, which membership type generated the least average total revenue?

Question 5 options:

a)

Couple

b)

Individual

c)

Group