Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
GenXY Motors Pte Ltd sells second hand cars. The company has four shops in different locations either within or outside of the city area. Mr. Branson Lim, the general manager of GenXY, would like to expand their business by adding four more locations. The main objective is to maximise revenue by increasing the number of cars sold and the prices of transactions. Mr. Lim would like know the followings: Where should the new locations be? What make (brand) of cars should they hold in these locations? What models of cars should they hold in these locations? What features should be built in as standard in these cars? What features should be added optionally? Mr. Lim came across a study done by the Car Dealers Association (CDA) on sales of cars in year 2012. The sample had 1000 transactions randomly selected from car dealers in the country. The sample proportions for make, model and locations are similar to those of the population. Mr. Lim speculates that this study could help him to address the above questions but he is not sure how to interpret this study. Mr. Lim has engaged you as a consultant to help and has provided you an excel file "cars_dataset.xlsx" with this random sample of 1000 transactions. The variables in the data are: CarID: Autogenerated ID of transactions in the sample Price$: Price of car sold in Singapore Dollars Mileage: Number of kilometres completed MakeID: Numeric ID of the make (or brand) of the car Make: Make (or brand) of the car ModelID: NumericID of the model of the car Model: Model of the car which briefly describes the main features of the car Engine Capacity: Size of the engine capacity Doors: Number of doors in the car Sound: Sound upgrading; 1 indicates an upgrade and 0 indicates no upgrade LocationID: Numeric ID of the location Store Location: Location; 1 indicates within the city and 2 indicates outside of the city Make ID Make Model ID Model Doors Location ID Store Location 1 Chery 1 2D Sedan 2 0 Non-city 2 Proton 2 4D Sedan 4 1 City 3 Hyundai 3 5D Hatchback 5 4 Nissan 4 MPV 5 5 Toyota 5 2D Sports 2 6 Honda 6 4D Sports 4 7 Others 7 4D Luxury 4 MPV: Multipurpose Vehicle BUS105e Copyright © 2014 SIM University Page 7 of 8 ECA - January Semester 2014 Part I 1. Select three (3) factors (variables) from the data. There should be at least one (1) quantitative and one (1) qualitative variable. Describe the data by using appropriately chosen charts. Explain why you have chosen the charts you used. 2. Calculate and interpret the measures of location and dispersion for these variables. Explain when these measures are suitable for analysing the variables. 3. Identify the probability that a random transaction has a price that is more than $95,000. From past data, the population distribution for Price$ is normal with a mean of $82,333 and a standard deviation of $20,100. Discuss whether the probability can be computed if the population distribution is not normal. Part II Execute a statistical test to analyse which variables affect the price of cars significantly. You must do the following: 1. First, state your hypothesis and select an appropriate test to test your hypothesis. You must explain why you choose the test. 2. Identify and fit a suitable linear regression model to the data and interpret relevant statistics. 3. Determine two (2) Makes and two (2) Models that GenXY Motors should stock. Explain your choices. 4. Describe the relationship between the price and variables implied by the regression model you have estimated in question 2. 5. Discuss whether the assumptions used in estimating the regression model are valid for the data. Part III 1. Apply a Correlation Analysis between Price$ and each independent variable. Compare this analysis with the method used in Part II. Discuss which method you would prefer to explain the variations in prices. 2. Discuss any statistical limitations (if any) in this analysis and give explanations on how they could affect this analysis. 3. State possible improvements which you would recommend in terms of how data may be collected and analysed in any follow-up work.
Part IV 1. Describe your findings in a 300-word executive summary for GenXY Motors Pte Ltd. The purpose of an executive summary is to provide an overview of your analysis. Summarise your analysis by including the following: a. Your findings, conclusions, limitations and recommendations. BUS105e Copyright © 2014 SIM University Page 8 of 8 ECA - January Semester 2014 b. Essential analysis that support your findings, conclusions, limitations and recommendations. c. A concise description of how your analysis was done. Part V 1. Consider the company you are working for, or one you have worked at in the past. Identify a situation in which you believe a linear regression model could be applied. Identify the dependent and explanatory variables of interest for this model. SECTION B Prepare a video recording of the presentation of at least 3 minutes but not exceeding 6 minutes for Parts II and III. SECTION C Prepare a set of Powerpoint slides upon which the video presentation is based.
Find out the critical value for the given degrees of freedom of the F-test also the lower-tailed critical value of F test for the similar level of significance
Two airlines fly to Memphis. according to airport data for the past year, wings airlines planes arrived on time 330 times and were late 60 times. Global airlines planes arrived on time 430 times and were late 50 times.
Which component of a time series is most likely to occur? Which component has a pattern that must be complete in a single year and repeat from year to year?
Of 346 vending machines tested, 12 are found to be defective. Construct the 98 % confidence interval for the proportion of all defective vending machines.
The mean score of a college entrance test is 500, the standard deviation is 75 and the scores are normally distributed.
Suppose that a researcher does a study to see how level of anxiety (A 1 = low, A 2 = medium, A 3 = high) is used to predict exam performance (Y).
Is there sufficient evidence for concluding that true average repair time exceeds 200 min? Carry out a test of hypotheses using a significance level of .05.
Forty percent of the homes constructed in the Quail Creek area include a security system. Three homes were selected at random. What is the probability all three homes selected have a security system?
Among 12 adults randomly selected from this area, only 3 reported that their health was excellent. Find the probability that when 12 adults are randomly selected, 3 or fewer are in excellent health.
Find the probability that the driver was intoxicated or the pedestrian was not intoxicated?
A bond analyst is analyzing interest rates for corresponding municipal bonds issued by two different states. At α = .05, is there a difference in interest rates paid by two states?
One of the 4 bus drivers is also randomly selected. Let Y denote the number of students on his bus. Compute the expectations of X and Y?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd