You have just been hired as a cost analyst for NASA to work on the Intemational Space Station project. Your rst assignment is to analyze and then predict the cost of a water-circulation system for the Habitation Module. You are able to collect the following data conceming the cost and capacity of similar systems used on previous space missions. Using This data, you must now compute the estimated cost of a system that can store and circulate 325i: gallons ofwater. Howr much will the system cost? How much money could be saved if capacity is reduced to lllllll gallons? ETSIl gallons? How sure are you of these projections? Are they within generally accepted tolerance guidelines for submission to the Director of Space Station Operations? Is there a method you might use to make the regression equation more accurate, and if so what would you do? You may use Excel to help solve this problem. Water-Circulation System Data Mission GEMINI MERCU RY AFOILD SKYLAE SHUTTLE MIR 2. Using the fellewing infermatiun enneerning the years ef eellege attended and aimual ineerne, develnp the estimated regi'essien equatien, the r squared value, the standard ester, the eeefeient ef variatian, and estimate haw much a persen when attended cellege fer ve years eeuld expect ta make. Use a werksheet In help with this pmhlem Years aanllege Annual lnenme {K5}