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.  As part of a study designed to compare hybrid and similarly equipped conventional vehicles, a variety of classes of hybrid and all-gas model cars and sport utility vehicles (SUVs) were tested. The data showing the miles-per-gallon rating study obtained for two hybrid small cars, two hybrid midsize cars, two hybrid small SUVs, two hybrid midsize SUVs, and eight similarly equipped conventional models are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.Image transcription textG18 V X V fx A B C D E F G H I J K LMake/Model Class Type MPGRearrange the data for the… Show more… Show moreImage transcription texta. At the a = .05 level of significance,test for significant effects clue to class,type, and interaction. b. T… Show more… Show more  Math Statistics and Probability BUS 308 Share QuestionEmailCopy link Comments (0)