Requirement Analysis and Modelling Assignment
Added on 2020-05-28
13 Pages1832 Words94 Views
|
|
|
Running head: REQUIREMENT ANALYSIS AND MODELLING Requirement Analysis and ModellingName of the Student:Name of the University:Author’s note:
1REQUIREMENT ANALYSIS AND MODELLINGTable of ContentsIntroduction:...............................................................................................................................2Methods:.....................................................................................................................................2Data Description:...................................................................................................................2Data Cleaning:........................................................................................................................2Dependent Variable:...............................................................................................................3Independent Variable:............................................................................................................3Result:........................................................................................................................................4Discussion:.................................................................................................................................9Annotated Bibliography:..........................................................................................................11
2REQUIREMENT ANALYSIS AND MODELLINGIntroduction:The data provides information about an International firm of 2010. The rock and rollMarathon parent company of competitor group hires the firm. Here, we are finding asummary of the Rock and Roll Marathon in 2010.The Rock ‘n’ Roll Marathon series combines entertainment with running with livebands performing at every mile along the course and a post-race headliner concert. Marathonis organised as preliminarily a tourism-driven event with about 65% of runners visiting fromout of state. There are currently 14 races across USA provinces.The data analysis is carried out with the help of MS-Excel. The linear regressionmodels show the association between dependent variable and independent variables of boththe datasets.Methods:Data Description:More than 320000 competitors, more than 697000 expo attendees, more than 1million spectators and almost 65% competitors travel to event market in this research report. Competitors from all 50 states and 106 countries are involved in event demographics. Among the Marathon competitors, 58% are female and 42% are male. 84% people are between the ages 24-44 years. Only 67% people has income more than $60K and 38% peoplehas income more than $100K. We are eager to apply linear regression model developed from the current cities data to the potential cities data for determining which The Rock ‘n’ Roll Marathon series of USA city should expand. Data Cleaning:The data of Current cities contains some missing values. Hence, we deleted somevariables of the data that are-1.Marathon Registrations2.Relay RegistrationsThe data of Potential cities contains many missing values. Therefore, we deleted many variables of the data such as-1.Annual Leisure Visitors2.Percentage of Leisure Visitors3.Total Visitors4.Total Room Nights Available
3REQUIREMENT ANALYSIS AND MODELLING5.2009 Booked Rooms Nights6.Total Hotel Revenue7.RevPar8.Fortune 1000 companies9.Visitors per Fortune 1000 company10.Severe Weather Risk11.Total Local Attractions12.Average Local Age13.Average Local HHI14.Years Event ExistedThe data of “Raleigh” is also removed for having lots of missing values.Dependent Variable:In the data of current cities, we have identified four dependent variables andcorresponding independent variables in four linear regression models.In the data of potential cities, we have identified the dependent variable that is“Marathon Finishers per 1000 Residents”. It is also known as response variable. Independent Variable: The dependent variables of the four linear regression models of the Current city are-A.1.Total City Population2.Total Room Nights Available3.Average Daily Hotel Rate4.Total Metro Area PopulationB.1.Half and Full Marathons2.Full Marathons Only3.Half Marathons Only4.Annual Leisure Visitors5.Annual Visitors6.Percent Leisure Visitors7.Total Hotel RoomsC. 1.Average Annual Temperature2.Average Event Month High Temperature3.Average Event Month Low Temperature
End of preview
Want to access all the pages? Upload your documents or become a member.