Create a trip generation model for trips variable

Assignment Help Other Subject
Reference no: EM13855749

Create a trip generation model for "Trips" variable using EXCEL to perform linear, least squares multiple regressions. The equation will be of the form y = bo + brxl + brx2 where y is the number of trips (dependent variable) and x are the independent variables.
Follow the steps in class slide "Steps in Multivariate Model Development"

1. Review data

- Plots of all dependent vs independent variables

• Analyze apparent and likely relationships (signs + / -)

• Reasonableness of using data (continuous? indicator?)

- Check relationships and correlations, plot independent variables

• Any correlations > 0.5 ?

2. Estimate model (s)

- Do I need to add or remove a variable based on step 1?

- Check if signs are intuitive

- Inspect goodness of fit measures and coefficient estimates, p-values

- Remove, 1 at the time, variables with p-values > 0.05 (start with the highest)

3. Create and analyze diagnostic plots (y vs x)

- Observed vs predicted

- Residuals vs. predicted

- Standardized residuals vs. predicted

- Based on what you learned repeat steps 2 and 3 or stop and recommend a model.

4. Recommend a final model. Interpret the meaning of each coefficient. Create a summary table showing the model equation, the R-squared value, the intercept, the coefficient, and the p-value for each variable in the final model. Analyze the final model: does the sign of the coefficients make sense? What is the overall goodness-of-fit? Comment if you have done further exploration of the data (e.g. outliers)

5. What is the probability that a household with 3 members, 2 adults, no access to transit, in an urban area, with $40,000 income, 2 workers, and 2 vehicles will generate more than 8 trips?

6. A developer is proposing to build 20 units for households as described in point 5. What is the forecasted number of average trips per day? Give an estimate of the maximum number of trips per day with a 95% confidence level. If this number is too high and the developer wants to reduce the forecast, what can he/she do?

Attachment:- Data.xlsx

Reference no: EM13855749

Questions Cloud

Explain competitive advantage for kudler fine foods : Recall how you determined if you created value and sustained competitive advantage for Kudler Fine Foods. While implementing this strategy, what factors would you monitor and evaluate to determine if you were successful. Why would monitoring and e..
Create a climate in which healthy banking institutions saw : However, the crisis did create a climate in which healthy banking institutions saw an opportunity to merge with and/or acquire competing banks.
What is the connection between correlation and causation : What other variables might be influencing this relationship and what is the connection between correlation and causation - what are some of the factors that affect the size of this correlation
Describe the implications for organizational leaders : Write a 2,000 word paper in APA format incorporating the feedback from your instructor throughout the course using the Business Design outline below. Apply an overview of the foundations examined throughout the course to a specific industry or co..
Create a trip generation model for trips variable : Create a trip generation model for "Trips" variable using EXCEL to perform linear, least squares multiple regressions. The equation will be of the form y = bo + brxl + brx2 where y is the number of trips.
Find the average value of the entire portfolio : Construct a table or a tree diagram of joint probabilities and what is the probability that a randomly chosen Canadian adult believes in Santa Claus?
Describe a mystical experience as understood : describe a mystical experience as understood within philosophy or one of the five religions we study in this course.
How do you define faith and doubt in the context : How do you define faith and doubt in the context of your life?
What ethical issues are raised : What ethical issues are raised

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd