use Microsoft Excel to derive regression results and answer the questions accordingly

4.30 Dr. Lillian Fok, a New Orleans psychologist, special- izes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how many patients Dr. Fok has seen each year for the past 10 years. It also indicates what the robbery rate was in New Orleans during the same year: YEAR 1 1 2 3 4 5 6 7 5 6 7 8 9 10 NUMBER 36 33 40 40 41 40 55 60 54 58 61 OF PATIENTS ROBBERY RATE PER 1,000 58.3 61.1 73.4 75.7 81.1 89.0 101.1 94.8 103.3 116.2 POPULATION Using trend (linear regression) analysis, predict the number of patients Dr. Fok will see in years 11 and 12 as a function of time. How well does the model fit the data? PX