Question

(Y and x) linear regression example with a made up numbers. Please provide a chart and made up Question and numbers. I provided my question below. . Please help with the rest. Say you’re planning to save $60,000 dollars to buy a new pool. based off the salary 0f $6,000 month and your Bills on estimate of $3,250 mouth how many years will it take to save enough to buy the pool. First item on your checklist? Budget! It’s a monthly savings — approximately $2,500, so a total of 12 months a year. The follow-up question: How many months should I allocate for the pool? This is a very important question. You enough money to enjoy your day to day life style. How much money should you allocate for the pool? You approach this problem with a science-oriented mindset, thinking that there must be a way to estimate the amount of money needed, based on the bills. First, you look at some data. You've been laboriously tracking your house hold bills for the last year — because who doesn’t! — so somewhere in your computer there's this spreadsheet. I need a made up spreadsheet with hypothetical numbers. Thank you

Answer 1

Here is the sample spreadsheet of the last years' house hold bills. We will take the decision on the basis of this spreadsheet. The bills are divided into different types and the monthly spend is shown.

Last Year Bills	January	February	March	April	May	June	July	August	September	October	November	December
Electricity	998	960	988	1027	1096	1060	1001	923	945	1052	1011	1088
Food	889	830	824	845	829	826	867	896	809	879	856	888
Gas	444	409	457	414	500	473	425	416	424	478	428	400
Water	219	240	229	235	229	252	257	203	210	201	241	243
Council Tax	194	158	190	125	108	182	109	124	152	187	127	125
Home Insurance	51	78	69	54	83	62	83	51	85	74	58	57
Telephone	82	88	112	94	106	109	110	117	104	119	109	100
Credit Card Bill	222	237	294	212	294	280	229	224	299	202	280	199
Others	151	0	137	394	105	6	219	546	572	8	190	0
Total	3250	3000	3300	3400	3350	3250	3300	3500	3600	3200	3300	3100