Linear Regression and Correlation Problem
jeryvaREGRESSION PROBLEM:
This file contains a table on the Price of Contracts. The question to be answered here is whether there is a significant relationship between the number of contractors that bid on a contract the price that the lowest bidder that offers who is eventually offered the contract. Use a Regression equation to determine the Nature of the relationship between the dependent variable (Final Price) and the Independent Variable (The number of Bidders) Is this relationship Significantly Negative or Positive? How Strong is the Relationship? Specify and Write out the Final Equation of the Model
~Ex13-49.xls (22.5 KB)
| Bidders | Price |
| 9.00 | 5.10 |
| 9.00 | 8.00 |
| 3.00 | 9.70 |
| 10.00 | 7.80 |
| 5.00 | 7.70 |
| 10.00 | 5.50 |
| 7.00 | 8.30 |
| 11.00 | 5.50 |
| 6.00 | 10.30 |
| 6.00 | 8.00 |
| 4.00 | 8.80 |
| 7.00 | 9.40 |
| 7.00 | 8.60 |
| 7.00 | 8.10 |
| 6.00 | 7.80 |
13 years ago
25
Answer(1)![blurred-text]()
Purchase the answer to view it
ex13-49.xlsx
Bids(1)
other Questions(10)
- Acc211 Fundamental Accounting Principal MacGraw Hill Connect Final Exam
- a movie theater sells popcorn in small, medium, large, and jumbo sizes. the customers of the first show purchase 4...
- What was the goal of the Missouri Compromise?
- HEEEEELPPPPPPP :( STRUCTURAL ANALYSIS???
- Torts and privacy
- Rebecca has 18 roses and 24 tulips. She wants to make identical bouquets with three roses in each bouquet.HYow many...
- Question 1: What is your opinion concerning the use of the following to power a home (heating and/or cooling and...
- i have to forecast a recurrences: http://acs.ist.psu.edu/courses/ist230/exercises/topic2/ex8-fcst/ex08.pdf there is a chart that he made for us, but I would need your email...
- Find a partner. Put your hands on the shoulders of your partner and have him/her do the same. Move...
- what are the limitations of the fossil record
