Calculate the following by hand, not Excel

There is a projected about five-year fuel cost that estimates how much the vehicle will cost over5 years in fuel, on average. For example, the BMW X5has an estimated five-year fuel cost of $8750. 1. Visualize the data with a side-by-side boxplot, name a title and give horizontal axis a name. add title Non-Guzzler Guzzler Guzzler 5000 10000 add horizontal axis nameThis is the output of a data set. > # Calculate the mean, sd and sample sizes for five year fuel cost split among Guzzler and no Guzzler # the command aggregate() will perform the given function on the specified groups # aggregate (response~treatment, data = datasetname, function) > # Make a table of values with the results. > > aggregate (FiveYearEstimatedCost~Guzzler, data = cardata, mean) Guzzler FiveYearEstimatedCost JH Guzzler 8666. 667 2 Non-Guzzler 2304. 328 > aggregate(FiveYearEstimatedCost~Guzzler, data = cardata, sd) Guzzler FiveYearEstimatedCost H Guzzler 1437 . 391 2 Non-Guzzler 2590.439 > aggregate(FiveYearEstimatedCost~Guzzler, data = cardata, length) Guzzler FiveYearEstimatedCost JH Guzzler 30 2 Non-Guzzler 543 2. Describe the distribution in context. Is there visual evidence the average five-year fuel cost is different between the Guzzler and Non-Guzzler vehicles? Explain._3. Provide an organized table of the summagg statistics. Include the sample means, standard deviations and sample sizes for each group. Round to nearest whole number. Fill this table. Mean Standard Deviation Sample Size Guzzler NonaGuzzler What type of vehicles are guzzlers