Classification: Regression Analysis Essay

Submitted By Abdullah-Issa
Words: 438
Pages: 2

Investigation 1: Doctors in Alaska
Data:
years since 1999 number of doctor in Alaska
Regression equation(y=978.42e^0.0768x)
0
1054
978.42
1
1124
1056.5
2
1174
1140.9
5
1463
1436.5
7
1547
1657
8
1556
1808.7
9
1546
1953
13
3521
2655.4
Graph:

Steps and results: The first thing I did after writing the data for the doctors in Alaska on a paper and with the help of excel 2013 a table as shown above was constructed, then I made a scatter plot as told in question number 1, then by adding the appropriate trend line(appropriate regression) to my graph which showed me my regression function(equation) and the r2 (0.8262) value which was easy to choose the best one that fit my equation.
Investigation 2: Nurses in Alaska
Data:
years since 1999 number of nurses in Alaska
Regression equation (y= -69.732x+6044.7)
0
7350
6044.7
1
5030
5975
2
4930
5905.2
5
6800
5696
7
5260
5556.6
8
5150
5486.8
9
5350
5417.1
13
5350
5138.2
Graph:

Steps and Results: For this graph, as in the investigation 1, I took the data graphed it and made a data table, however this graph was the hardest one to pick the appropriate regression for because the r2 values were really close, the linear regression was 0.1193, the exponential was 0.1192 and the log.regression was 0.1190, and other values were close as well, so I did my best and compared all of them and turned out that the linear regression was the most fit for this data.
Investigation 3: Nurse to doctor ratio in Alaska
Data:
years after 1999
Nurse to Doctor ratio
Regression equation(y=6.0668e^-0.087x)
0
6.973434535
6.067
1
4.475088968
5.561
2
4.199318569
5.097
5
4.647983595
3.926
7
3.400129282
3.299
8
3.309768638
3.024
9
3.460543338
2.772
13
1.5194547
1.957
Graph:

Steps and Results: Finally the last investigation which was to graph the ratio of nurses to doctors which was pretty challenging, at first I divided the nurses by the doctors at which point I decided to use the (Auto complete) feature which