I need help analyzing and computing the data found in the attached…

Question Answered step-by-step I need help analyzing and computing the data found in the attached… I need help analyzing and computing the data found in the attached spreadsheet. (10.2 A1) Image transcription textThe U.S. Department of Transportation provides the number of miles that residents of the 75 largest metropolitan areas travel per day in a car. Independent simple random samples for both Buffalo and Boston are located in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet Round your answers to one decimal place. a. What is the point estimate of the difference between the mean number of miles that Buffalo residents travel per day and the mean number of miles that Boston residents travel per day? b. What is the 95% confidence interval for the difference between the two population means?to … Show more  Math Statistics and Probability BUS 308 Share QuestionEmailCopy link Comments (0)