Show a scatter diagram to include labels

Assignment Help Basic Statistics
Reference no: EM132413717

Problem: The following table provides information on the living area (sq ft) and price (in thousands of dollars) of 10 randomly selected houses listed for sale. Use an excel spreadsheet to perform analysis and answer questions #1-9.

Living Area - 3008 (sq ft) 2032 2272 1840 2579 2583 1650 3932 2978 2176

Price - $275 220 255 189 260 284 172 370 295 260

Requirement:

  1. Enter x, y data provided into excel sheet.
  2. Show a scatter diagram to include labels.
  3. Run the data analysis tool with 93% confidence interval.
  4. Label SST, SSR and SSE. Explain SST as it relates to the problem.
  5. Label a (y-intercept) and b (slope). Describe each as they relate to the problem.
  6. Use the values from #5 to to show a regression line.
  7. Label the standard error.
  8. Label the r and rvalues. Explain if this is a good model or not. (please use correct values for r and r2)
  9. Explain the residuals in the last section of the data analysis output.
  10. Be sure that your Excel sheet has original input values from #1, #2, and the regression sheet. Answers that don't need typed into excel may be typed into a separate word doc or directly into excel sheet.

Reference no: EM132413717

Questions Cloud

Standard deviation of the weight of the final product : (a) What is the probability that the first operator cuts a disc that is more than 470g and less than 530g?
Distinguish between dependency and delinquency : Write a 1,050- to 1,400-word paper summarizing the key parameters of the juvenile justice system in the United States. The historical development of the.
Determine the probability that a randomly selected book : Problem: In a bookshop, the weights of books are modelled by a normal distribution with mean 8.5kg and standard deviation 1.5 kg
Define how would you handle the situation : What if you were a security guard for a local mall and witnessed a youth enter the main entrance wearing a long, heavy, leather coat but it was a very hot.
Show a scatter diagram to include labels : The following table provides information on the living area (sq ft) and price (in thousands of dollars) of 10 randomly selected houses listed for sale
Create a Digital Asset : Create a Digital Asset (such as an Industry Guide or a Position Paper or a Guided Conversation) that positions you as an expert in your industry niche
How would you document the need for change : How would you document the need for change? What data would you collect and analyze in order to define the problem? What do you believe may cause or be causes.
State the appropriate null and alternate hypotheses : It is hoped that the new formula may reduce this infestation rate. State the appropriate null and alternate hypotheses.
Determining the number of instructors hired : What factors should be considered in determining the number of instructors hired to staff the education program? Should there be any restrictions in terms.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Correct scores on a standardized reading test

The scores shown below are the number of correct scores on a standardized reading test for a random sample of 6th grade students from Washington Elementary.

  Find the mean and median of the flight times

Explain why the flight times are a population. Find the mean and median of the flight times. Find the range and the standard deviation of the flight times.

  Number of miles a customer drives

A marketing manager at a rental-car agency believes that the number of miles a customer drives per week is related to the type of car rented.

  The owner of a donut shop wishes to determine the best mix

the owner of a donut shop wishes to determine the best mix for her three products zingers crullers and eacuteclairs.

  Sixty percent of all road accidents are due to distracted

sixty percent of all road accidents are due to distracted driving. in a random sample of 100 accidents what is the

  What is most significant issue was in the upcoming election

A poll of 1,200 voters asked what the most significant issue was in the upcoming election. Sixty-five percent answered the economy.

  Describe the two quantitative variables of interest

Describe the two quantitative variables of interest, and tell which is explanatory and which is response.

  What is the population mean

If the standard deviation of a population is 2.14 and your sample mean is 6, and you know that 15.1% of the population would be below your sample

  Determine number of people who are affected by the hum

To determine if more people are affected by the Hum, a random sample of 1300 adults in Taos, New Mexico, was obtained, and 24 reported that they regularly hear.

  What is the probability that at least 30 of them would pass

If we randomly select 20 statistics students, what is the probability that exactly half of them would pass?

  What are maximum and minimum number of cell phones sold

What are the maximum and the minimum number of cell phones sold in a day? What is a typical number of cell phones sold?

  Let x1x2x3 be a random sample of size three from a

let x1x2x3 be a random sample of size three from a distribution with the probability density function.fx 2x 0ltxlt1find

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