Calculate regression analysis

Assignment Help Basic Statistics
Reference no: EM13828711

A planning official in the Texas Department of Community Affairs, which works in the office next to you, has a problem. He has been handed a data set from his boss that includes the costs involved in developing local land use plans for communities with populations between 75,000 and 125,000. The boss has a hunch that the plans are more expensive as population increases. He has no idea how to decide and asks for your assistance. Given the data in the following table, using regression analysis, are the plans more expensive (I mean statistically significantly different) as population increase?  You must use SPSS for this question.

Community    Population      Cost       

1                    77000          12500

2                    87000          13700

3                    76000          12000

4                  124000          23000

5                  100000          21000

6                  110000         19000

7                  115000         22000

8                    98000         18000

9                    87000         13500

10                 123000         27000

11                   95000         17000

12                 121000         21000

13                 113000         22000

14                 105000         19000

15                 102000         17000

16                 104000         23000

17                   75000         14000

18                   85000         14000     

From the above given data, using your linear regression, predict the cost of the city plan for a community with a population of 250,000. Explain and discuss your model in detail. For example how well does it explain the variation in plan cost? Do the model's residuals behave appropriately? In short discuss the pluses and minuses regarding your model.

Additional Information
This question based on the Statistics and it is about calculating communities that have been allotted land and the cost of such allocation with population of the community as a parameter. A regression analysis needs to be done, which has been given in detailed in the solution.

Word limit 220

Reference no: EM13828711

Questions Cloud

Strategic plans and operational plans : What are the differences between strategic plans and operational plans? Name 2 main purposes of the operational plans.
Probability is the chance of an event happening : Probability is the chance of an event happening. During the day, you may hear various probabilities, such as a 30% chance of rain or a 50% chance of winning a contract bid. Two of the main types of probability are classical (theoretical) and empirica..
Importance of a performance management system : Outline the importance of a performance management system in achieving organizational goals and critically discuss issues surrounding its implementation.
Difference between value type and reference : Difference between value type and reference type arguments in c#
Calculate regression analysis : Calculate Regression Analysis
Error on a typical public telephone line : The probability that a single bit will be in error on a typical public telephone line using 4800 bps modem is 10 to the power -3. If no error detection mechanism is used, the residual error rate for a communication line using 9-bit frames is approxim..
Performance management in the wake of unionized firms : Write a report about performance management in the wake of unionized firms.
Objective of the customer perspective of balanced scorecard : Which of the following is an advantage of standard costs? Which of the following is an objective of the customer perspective of a balanced scorecard? The objective of reducing waste refers to which perspective of a Balanced Scorecard?
Find the some ratio analysis for disney for 2014 : Find the some ratio analysis for Disney for 2014. Would you be able to help me complete some of the other answers and check if the ones I've done are correct?

Reviews

Write a Review

Basic Statistics Questions & Answers

  A study of cats and dogs found that 25 of 45 cats and 44 of

a study of cats and dogs found that 25 of 45 cats and 44 of 60 dogs slept more than 10 hours per day. at the .05 level

  To provide information on whether coatings on iron pipes

to provide information on whether coatings on iron pipes are of any use 10 pieces of pipe are each marked off in equal

  Compute the standard error of the mean

Compute the standard error of the mean O(funny o with line) line over x, for sample sizes of 50, 100, 15o, and 200. What can you say about the size of the standard error of the mean as the sample size is increased?

  Find probability respondent said team in rose bowl

What is the probability that a respondent said neither the Big Ten nor the Pac-10 will have a team in the Rose Bowl?

  You also choose at random a device to do your hw on but is

you have an ipad and a laptop. you grab one essentially at random and are twice as likely to take the ipad rather than

  Five step hypothesis on using non-parametric hypothesis

Perform the five-step hypothesis test on the data. - LORA - this is the portion I am responsible for based on using the nonparametric hypothesis testing.

  What is the probability that the three pieces so obtained

two points are selected at random independentlyand uniformly along a 1-meterlong stick and the stick is broken at the

  Mean and standard deviation for number of erroneous returns

Determine mean and standard deviation for number of erroneous returns per batch.

  Probability through discrete probability distribution

What is the probability of flipping a coin 6 times and getting 4 or more heads?

  Standard deviation of distribution

In a group of six professors selected at random, what is the expected number of extroverts? What is the standard deviation of the distribution?

  Draw histogram for data using initial class boundary

Draw the histogram for these data using an initial class boundary of 29.5 and a class width of 6. Note that you can add or remove classes from the figure

  What is the probability in percent that a variable will be

what is the probability in percent that a variable will be within plusmn1.5 standard deviations of the

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