- Banned
- #1
For a maths assignment I have to draw a scattergram (graph using chart wizard I think) with these values.
VALUATION (x) --| $110,000 | $115,000 | $120,000 | $125,000 | $130,000 | $160,000 | $170,000 | $180,000 |
WEEKLY RENT (y) | $155 | $155 | $160 | $165 | $165 | $180 | $185 | $190 |
Now I enter the data into excel, then highlight them. I presume I go to chart wizard next.
Then I need to get a graph of Weekly Rent(y) vs Valuation(x), would I use XY scatter? If so then how do I do line of best fit and find the equation of the line of best fit?
And how do I get the first values to be $100,000 for valuation and $150 for Weekly Rent at where 0 would normally be in the bottom left corner?
Help would really be appreciated, my last question on my maths assignment due tomorrow.
VALUATION (x) --| $110,000 | $115,000 | $120,000 | $125,000 | $130,000 | $160,000 | $170,000 | $180,000 |
WEEKLY RENT (y) | $155 | $155 | $160 | $165 | $165 | $180 | $185 | $190 |
Now I enter the data into excel, then highlight them. I presume I go to chart wizard next.
Then I need to get a graph of Weekly Rent(y) vs Valuation(x), would I use XY scatter? If so then how do I do line of best fit and find the equation of the line of best fit?
And how do I get the first values to be $100,000 for valuation and $150 for Weekly Rent at where 0 would normally be in the bottom left corner?
Help would really be appreciated, my last question on my maths assignment due tomorrow.
lol
