Question Details

(solution) Hi I'm now working with statistics project. Tutor provides


Hi

I?m now working with statistics project. Tutor provides questions and data for me and I have to analyze and write down as a report.

The background of the questions is

?You are working as a business analyst for Your Market Consultants Australia (?YMCA?), a small Sydney;based company that specializes in providing statistical consulting services to Australian companies seeking intelligence about their present or potential customers. LifeActive, an owner of several large fitness centres in Sydney, contacts YMCA. You are told that the marketing director at one of LifeActive?s centres, Rachel Sprint, is interested in using market research and statistical analysis to build a group fitness program that meets the needs of their members and management. ?

I was provided the data set with 14 variables which are

pid = survey response identifier

visits = total number of fitness classes attended on this visit

dayofweek = day identifier, taking values 1 (Monday) through 7 (Sunday)

freqgymvisit = responder?s estimate of his/her number of visits to gym the last 3 weeks

timespent = responder?s estimated amount of time (in minutes) spent, in total, at the gym on this visit timeofday = binary indicator of time of the day of the respondent?s visit (assessed by interviewer), where

0= morning 7am;10am 1= noon 11am;1pm 2 = afternoon 2pm;4pm 3 = evening 5pm;7pm 4 = late evening 8pm;10pm

age = binary indicator of respondent?s age (assessed by interviewer), where 0= under 15

1= 15;20 2 = 21;30 3 = 31;40 4 = 41;50 5 = 51;60 6 = 61 or over

HHinc = total household income of the respondent, where: than $40,000 per year; 2=$40,000;$80,000 per year; 3=$80,000;$120,000 per year; 4=$120,000;$160,000 per year; 5=$160,000;$200,000 per year; 6=$200,000 or more per year.

sex = binary indicator of respondent?s sex (assessed by interviewer), where

HIIT = binary indicator where:

respondent attended a High intensity Interval Class on this visit

respondent did not attend a High intensity Interval Class on this visit

SPIN = binary indicator where:

respondent attended a spinning Class on this visit

respondent did not attend a spinning class on this visit

PUMP= binary indicator where:

respondent attended a pump class on this visit

respondent did not attend a pump class on this visit

Abs= binary indicator where:

respondent attended an Abs workout class on this visit

respondent did not attend an Abs workout class on this visit

other= binary indicator where:

respondent attended another type of group fitness classes on this visit

respondent did not attend any other type of group fitness exercises

The one question is ?whether the timing of those classes is right and whether their workout program is a good match for our members.?

So what method should I use to analyze this question / what types of diagrams or tables should I use?

And how? thanks


UNSW School of Economics ! ! ECON1203 Business and Economic Statistics

 

Session 2, 2016 ! ! ! ! !

 

! ! ! ! Major project:

 

The Fitness Challenge

 

Purpose

 

The!idea!is!of!this!assignment!is!to!simulate!a!professional!work!task!involving!statistical!analysis.!It!is!designed!

 

to! help! students! learn! about! what! is! involved! in! undertaking! basic! statistical! analysis! to! understand! a! real;!

 

world!problem,!and!communicating!the!results!of!this!analysis!to!business!stakeholders.! Context and Problem

 

You!are!working!as!a!business!analyst!for!Your!Market!Consultants!Australia!(?YMCA?),!a!small!Sydney;based!

 

company!that!specializes!in!providing!statistical!consulting!services!to!Australian!companies!seeking!

 

intelligence!about!their!present!or!potential!customers.!LifeActive,!an!owner!of!several!large!fitness!centres!in!

 

Sydney,!contacts!YMCA.!!You!are!told!that!the!marketing!director!at!one!of!LifeActive?s!centres,!Rachel!Sprint,!

 

is!interested!in!using!market!research!and!statistical!analysis!to!build!a!group!fitness!program!that!meets!the!

 

needs!of!their!members!and!management.!

 

You! attend! a! breakfast! meeting! with! Ms! Sprint! and! a! senior! YMCA! consultant! to! discuss! her! concerns! in!

 

more!detail.! At!the!meeting,!Ms!Sprint!says:!

 

?So$the$situation$is$that$we$hired$a$market2research$firm$to$come$in$and$run$an$intercept$survey*$for$us,$which$

 

they$ did,$ and$ the$ data$ were$ collected$ in$ a$ single$ week$ in$ April$ 2016.$$ I?m$ now$ looking$ for$ someone$ with$

 

statistical$ expertise$ to$ analyse$ the$ data$ and$ give$ us$ some$ recommendations.$ Just$ which$ programs$ and$

 

instructors$will$create$the$perfect$balance$is$an$ongoing$challenge$for$our$business.$!

 

The$ whole$ reason$ we$ did$ the$ survey$ is$ to$find$ out$ what$ sort$ of$ members$ we?re$ attracting$ to$the$ gym,$ so$ we$

 

have$a$better$idea$of$what$group$fitness$classes$might$do$well$in$the$gym$and$the$best$time$to$schedule$them.$$

 

You$see,$25%$of$ our$fitness$instructors$are$terminating$their$contracts$at$the$end$of$next$year,$and$we$want$to$

 

know$ which$ kind$ of$ fitness$ instructors$ to$ approach$ in$ order$ to$ fill$ those$ vacancies.$ Some$ of$ our$ fitness$

 

instructors$ have$ also$ struggled$ to$ keep$ good$ class$ participation$ with$ consistently$ low$ class$ counts$ over$ long$

 

periods$of$time.$This$makes$me$wonder$whether$the$timing$of$those$classes$is$right$and$whether$their$workout$

 

program$is$a$good$match$for$our$members.!

 

My$sense$is$that$our$biggest$members$segment$is$high2income$young$women,$who$stay$at$the$centre$for$a$long$

 

time$and$are$the$main$participants$in$our$group$fitness$classes.$This$ would$ explain$ why$ our$ Aerobic$classes$

 

like$SPIN$and$Abs$classes$ are$ generally$ doing$ well.$I?d$expect$that$high2income$young$women$make$at$least$

 

20%$of$our$members,$but$I$am$happy$to$be$corrected$on$that.$We$ also$ have$ a$ community$ of$elderly$people$in$

 

the$neighborhood,$some$of$whom$are$regulars.!

 

So,$ the$ first$ information$ I?m$ looking$ for$ is$ a$ breakdown$ of$ member$ types,$ both$ overall$ and$ by$ group$ fitness$

 

type.$$ I?d$also$like$to$know$whether$we?re$hitting$LiveActive$internal$minimum$thresholds$of$35%$of$members$

 

attending$group$fitness$classes,$and$45$minutes$spent$per$member$on$each$visit.$Some$ information$ about$ the$

 

types$ of$fitness$classes$ in$ which$ participation$ and$ t i me$ spent$ are$clustered$for$our$different$member$types$

 

would$also$be$of$use.$$Anything$you$can$tell$me$about$how$to$improve$our$appeal$to$our$main$member$types,$of$

 

course,$would$be$a$great$extra!?! !

 

!

 

! Based!on!these!comments,!that!afternoon!you!and!the!senior!consultant!draw!up!a!consulting!brief,!which!you!

 

send! to!Ms!Sprint,!who! approves!it! and! hires!you! to!perform!the! analysis!required! to! address!her!concerns.!!

 

Ms!Sprint!then!sends!you!an!Excel!file!containing!the!data!from!the!intercept!survey.!

 

You!are!given!the!responsibility!of!providing!a!statistical!analysis!of!these!data!and!for!producing!an!associated!

 

report!that!addresses!Ms!Sprint?s!concerns.!

 

*intercept!survey:!a!survey!of!members!leaving!a!fitness!centre.! ! Report ! ! ! ! ! ! ! It!is!natural!to!associate!different!parts!of!the!project!work!with!the!coverage!of!relevant!material!in!particular!

 

Sharpe! chapters! and! lectures.! However,! remember! you! are! writing! a! professional! report,! not! providing! a!

 

sequence! of! answers! to!assignment! problems,! so! you! should! try! to! write! a! flowing! report! organized! around!

 

ideas,!not!methods.!

 

The!report!should!include!a!brief!Executive!Summary.!Ms!Sprint,!your!audience,!is!an!intelligent!person!but!she!

 

is!not!a!statistician.!Your!Executive!Summary!needs!to!be!non;technical!so!that!she!can!assess!what!you!have!

 

done!and!understand!your!basic!conclusions.!The!senior!consultant!at!YMCA!is!familiar!with!technical!analysis,!

 

and!will!be!reviewing!the!report!before!it!is!sent!out!to!the!client!to!ensure!that!the!conclusions!discussed!in!

 

the!Executive!Summary!are!reasonable!and!based!on!sound!statistical!analysis.!

 

You! can! see! from! the! marking! rubric! below! that! while! your! project! mark! will! be! based! primarily! on! the!

 

substance!of!your!statistical!work,!the!presentation!of!the!material!will!also!be!considered.!Reports!should!be!

 

typed! and! should! use! appropriate! graphical! techniques! to! represent! the! data,! as! well! as! other! appropriate!

 

statistical! analysis.! ! For! some! guidance! on! what! these! types! of! reports! might! look! like,! please! check! the!

 

?Project?!section!of!the!course!website!where!some!actual!examples!of!statistical!reports!are!posted.!

 

As# is#the# case# in# any# actual# work#environment,# there#is#no# ?one#right# way?# to# construct# a# report# like#this,#

 

and# hence# there# is# no# rigid# template# for# what# your# project# should# look# like,# nor# is# there# only# one# way# to#

 

approach#the#analysis.! Data

 

Each!student!will!be!assigned!a!personalized!data!set.!Each!individual!data!set!refers!to!the!problem!above!and!

 

has!the!same!structure.!However,!values!of!some!of!the!key!variables!will!vary!across!students,!meaning!that!

 

statistical!results!and!any!inferences!drawn!from!them!may!differ!across!students.!

 

In!the!?Project?!folder!on!the!website,!you!will!find!an!Excel!file!(?Project!Data.xls?)!that!you!will!download!in!

 

order! to! obtain! your! personalized! data! set.! Once! you! enter! your! zID! into! the! highlighted! cell! in! the! Excel!

 

worksheet,!a!personalized!data!set!will!be!generated!using!which!you!should!perform!your!analysis.!Copy#and#

 

paste# (using# "paste# special@values")# the# generated# data# into# a# new# Excel# workbook,# where# you# will#

 

conduct# your# analysis.## Each! data! set!will! contain! a! sample! of! 293! observations,! where! each! observation!

 

refers! to! a! separate! survey! response.!There!are!14!variables,!as!follows:!

 

pid$=!survey!response!identifier!

 

visits$=!total!number!of!fitness!classes!attended!on!this!visit!

 

dayofweek$=!day!identifier,!taking!values!1!(Monday)!through!7!(Sunday)!

 

freqgymvisit$=!responder?s!estimate!of!his/her!number!of!visits!to!gym!the!last!3!weeks!

 

2 !

 

!

 

!

 

!

 

!

 

!

 

! timespent$=$responder?s!estimated!amount!of!time!(in!minutes)!spent,!in!total,!at!the!gym!on!this!visit!!

 

timeofday$=$binary!indicator!of!time!of!the!day!of!the!respondent?s!visit!(assessed!by!interviewer),!where!!

 

0=!morning!7am;10am!

 

1=!noon!11am;1pm!

 

2!=!afternoon!2pm;4pm!

 

3!=!evening!5pm;7pm!

 

4!=!late!evening!8pm;10pm!

 

age$=$binary!indicator!of!respondent?s!age!(assessed!by!interviewer),!where!

 

0=!under!15!

 

1=!15;20!

 

2!=!21;30!

 

3!=!31;40!

 

4!=!41;50!

 

5!=!51;60!

 

6!=!61!or!over!

 

HHinc$=!total!household!income!of!the!respondent,!where:!

 

1=less!than!$40,000!per!year;!

 

2=$40,000;$80,000!per!year;!

 

3=$80,000;$120,000!per!year;!

 

4=$120,000;$160,000!per!year;!

 

5=$160,000;$200,000!per!year;!

 

6=$200,000!or!more!per!year.!

 

sex$=$binary!indicator!of!respondent?s!sex!(assessed!by!interviewer),!where!

 

1=female!

 

0=male!

 

HIIT$=!binary!indicator!where:!

 

1=the!respondent!attended!a!High!intensity!Interval!Class!on!this!visit!

 

0=the!respondent!did!not!attend!a!High!intensity!Interval!Class!on!this!visit!

 

SPIN$=!binary!indicator!where:!

 

1=the!respondent!attended!a!spinning!Class!on!this!visit!

 

0=the!respondent!did!not!attend!a!spinning!class!on!this!visit!

 

PUMP=!binary!indicator!where:!

 

1=the!respondent!attended!a!pump!class!on!this!visit!

 

0=the!respondent!did!not!attend!a!pump!class!on!this!visit!

 

Abs=!binary!indicator!where:!

 

1=the!respondent!attended!an!Abs!workout!class!on!this!visit!

 

0=the!respondent!did!not!attend!an!Abs!workout!class!on!this!visit!

 

other=!binary!indicator!where:!

 

1=the!respondent!attended!another!type!of!group!fitness!classes!on!this!visit!

 

0=the!respondent!did!not!attend!any!other!type!of!group!fitness!exercises! 3 Tutorial work

 

You! should! think! about! the! problem! and! plan! what! needs! to! be! done! before! you! actually! start! undertaking!

 

extensive! computing! work.!!!In! order! to! assist! in! this! process,! there! will! be! some! project! discussion! time! in!

 

tutorials.!You!should!generate!your!data,!and!then!copy,!paste,!and!save!it!into!a!new!Excel!workbook!that!you!

 

bring!along!to!class!as!part!of!your!preparation!for!your!Week!7!tutorial.!In!this!Excel!workbook,!you!should!take!

 

time!before!class!to!generate!some!descriptive!statistics!for!your!data!that!you!could!show!your!tutor!in!Week!

 

7.! This! will! confirm! that! you! have! correctly! created! your! data! set! and! that! you! are! ready! to! commence! your!

 

analysis.!These!descriptive!statistics!will!also!be!required!to!answer!a!Week!7!tutorial!question.!!

 

!

 

In! your! Week! 9! tutorial,! time! will! be! devoted! to! monitoring! your! progress! and! discussing! how! more! recently!

 

covered! material! might! be! relevant! to! the! project! tasks.! Naturally! you! should! consult! your! tutor! or! lecturer!

 

should!you!have!any!other!questions!regarding!the!project.! ! 4 ! Details

 

Length:!

 

Cover,sheet:! Project,mark:!

 

Due,date:! Late,submission:! Plagiarism:! Coverage:! ! No!longer!than!1200!words,!excluding!tables!and!graphs.!Total!length!including!

 

all!discussion,!tables!and!graphs!should!not!exceed!8!pages.!

 

Attach#the#project#assessment#sheet#(given#below)#as#your# first#page.#Check!

 

that# you# have# completed# the# top# (grey)# sections# in# full,# including# your#

 

signature.# Do! not! use! plastic! sheets! or! binders.! Simply! attach! the! completed!

 

cover!sheet!and!staple!the!pages!together.!

 

The! project! will! be! marked! out! of! 20,! and! will! constitute! 20%! of! your! total!

 

course!mark.!

 

A!hard! copy!of! your!assignment! is!to!be!submitted! to!your!tutor!in! or!before!

 

!your! scheduled! tutorial! in! week! 11! (beginning! October! 10).! In# addition# to#

 

the# hard# copy,# you# must# also# submit# an# electronic# copy# to# the# course#

 

website#by!

 

6# pm# on# Friday# October# 14.# Upload! your! assignment! via! the! Turnitin! link! on!

 

the!course!website.!Browse!and!upload!a!copy!of!your!document!;!do!not!paste!

 

20%!of!the!value!of!the!project!will!be!deducted!for!every!day!or!part!thereof!

 

text.!Use!your!student!zID!in!the!file!name!(e.g.,!z1234567.doc).!

 

that! the! hard! copy! is! turned! in! after! the! start! time! of! your! Week! 11! tutorial!

 

(including! the! weekend).! Projects! submitted! more! than! five! days! late! will! not!

 

be!marked!and!will!be!assigned!a!mark!of!zero.!You!can!and!should!be!working!

 

on!the!material!regularly!before!the!due!date.!Extensions!will!only!be!granted!

 

in! exceptional! circumstances! and!must! be! approved! by! the! lecturer;in;charge.!

 

For!more!details!about!late!submission,!see!the!Course!Outline.!

 

While! you! are! encouraged! to! discuss! the! project! with! other! students,! each!

 

person! must! submit! an! individual! assignment! that! represents! his! or! her! own!

 

work.! All! assignments! will! be! checked! for! plagiarism! on! the! Turnitin! software!

 

into!which!they!are!uploaded.!The!software!will!automatically!check!against!all!

 

other! projects! ever! submitted.! Material! copied! from! previous! projects! will! be!

 

found! and! the!source!will!be!identified.!Evidence!of! plagiarism!will!be!treated!

 

extremely!seriously:!automatic!and!immediate!failure! in!the!course!is!a!possible!

 

penalty.! ! See! Part! B! of! the! course! outline! for! further! details! about! UNSW?s!

 

policies! on! plagiarism.! ! If! you! are! in! doubt! about! how! to! identify! or! avoid!

 

plagiarism,! follow! the! link! to! and! complete! the! self;paced! Working! with!

 

Academic!Integrity!module!on!Moodle.!

 

In!!your!!work!!for!!this!!project,!!you!!are!!only!!expected!!to!!use!!the!!statistical!

 

techniques!developed!in!the!text!and!lectures!up!until!the!end!of!week!9.! 5 ECON1203 Business and Economic Statistics

 

PROJECT ASSESSMENT

 

zID###

 

#

 

Tutorial#Group#(Tutor,#Time#and#Place)###

 

#

 

##!

 

I!declare!that!this!assessment!item!is!my!own!work!except!where!acknowledged,!and!acknowledge!that!the!assessor!of!this!item!may,!for!

 

the!purpose!of!assessing!this!item:!

 

(1)!Reproduce!this!assessment!item!and!provide!a!copy!to!another!member!of!the!University;!and/or!!

 

(2)!Communicate!a!copy!of!this!assessment!item!to!a!plagiarism!checking!service!(which!may!then!retain!a!copy!of!the!assessment!item!on!

 

its!database!for!the!purpose!of!future!plagiarism!checking)!

 

Name### ! I!certify!that!I!have!read!and!understood!the!University!Rules!in!respect!of!Student!Academic!Misconduct.!

 

Signed###

 

Date###

 

# ANALYSIS and DISCUSSION (14 marks)

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

!

 

! Characterizing#key#features#of#the#data#(7#marks)!

 

Missing! (! )! Poor!!(! )! Adequate!!(! )! Good!(! )! Excellent!(! )!

 

Motivation,#production#and#evaluation#of#hypotheses#(3#marks)!

 

Missing! (! )! Poor!!(! )! Adequate!!(! )! Good!(! )! Excellent!(! )!

 

Justification#of#main#conclusions#(2#marks)!

 

Missing! (! )! Poor!!(! )! Adequate!!(! )! Good!(! )! Excellent!(! )!

 

Executive#summary#(2#marks)!

 

Missing! (! )! Poor!!(! )! Adequate!!(! )! Good!(! )! Excellent!(! )! MECHANICS (6 marks)

 

Presentation#(3#marks)!

 

Poor! (!!)! Adequate!!(! )! Good!(! )! Excellent!(! )!

 

Use#of#graphics#(3#marks)!

 

Missing! (! )! Poor!!(! )! Adequate!!(! )! Good!(! )! Excellent!(! )!

 

Other!

 

Some!problems!with!spelling! (!!)! Poor!spelling! (! )! Some!problems!with!grammar! (!!)! ! Poor!grammar! (! )!

 

Some!confused!or!off;target!discussion!and!interpretations!!(! )! Well!argued! (! )! Too!long!(you!need!to!condense!your!argument)!!(! )! GENERAL COMMENTS ! 6

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now