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)

Succinctly and concisely using relevant summary output, describe the relationship between "Total Revenue" and "Membership Type"