代写ECON1203 Business and Economic Statistics
100%原创包过,高质代写&免费提供Turnitin报告--24小时客服QQ&微信：120591129
代写ECON1203 Business and Economic StatisticsUNSW 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$ time$ 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!”!
! 2
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.!
代写ECON1203 Business and Economic Statistics
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.!
代写ECON1203 Business and Economic Statistics
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!
! 3
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;!less!than$80,000!per!year;!
3=$80,000;!less!than!$120,000!per!year;!
4=$120,000;!less!than!$160,000!per!year;!
5=$160,000;!less!than!$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!one!or!more!High!intensity!Interval!Classes!on!this!visit!
0=the!respondent!did!not!attend!any!High!intensity!Interval!Class!on!this!visit!
SPIN$=!binary!indicator!where:!
1=the!respondent!attended!one!or!more!spinning!Classes!on!this!visit!
0=the!respondent!did!not!attend!any!spinning!class!on!this!visit!
PUMP=!binary!indicator!where:!
1=the!respondent!attended!one!or!more!pump!classes!on!this!visit!
0=the!respondent!did!not!attend!any!pump!class!on!this!visit!
Abs=!binary!indicator!where:!
1=the!respondent!attended!one!or!more!Abs!workout!classes!on!this!visit!
0=the!respondent!did!not!attend!any!Abs!workout!class!on!this!visit!
other=!binary!indicator!where:!
1=the!respondent!attended!other!types!of!group!fitness!classes!and/or!used!other!gym!facilities!
on!this!visit!
0=the!respondent!did!not!attend!any!other!types!of!group!fitness!exercises!nor!did!used!the!gym!
facilities!on!this!visit!
!!!!!
! 4
!
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.!
! 5
!
Details
Length:! No!longer!than!1200!words,!excluding!tables!and!graphs.!Total!length!including!
all!discussion,!tables!and!graphs!should!not!exceed!8!pages.!
Cover,sheet:! 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.!
Project,mark:! The! project! will! be! marked! out! of! 20,! and! will! constitute! 20%! of! your! total!
course!mark.!
Due,date:! 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!
Late,submission:! t2e0x%t.!!oUfs!eth!yeo!vuar!lsuteu!doef!ntth!ezI!Dp!rionj!ethcet!!wfiliell!!nbaem!dee!d(eu.cgt.e,!dz1!f2o3r4!e5v6e7r.yd!odca)y.!or!part!thereof!
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.!
Plagiarism:! 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.!
Coverage:! 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.!
! 6
ECON1203 Business and Economic Statistics
PROJECT ASSESSMENT
Name### 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)!
!
!
!
代写ECON1203 Business and Economic Statistics
