Stat Project 1 All submissions should be in the form of a single Word document where appropriate, but all of the Excel portions of the assignment should be sent as Excel attachments. 1. Excel Project: Apple's recent mission to reduce its carbon- footprint led the company to purchase solar panels, and locate two potential building sites. Because Apple could only create one large-scale solar powered project, a comparative test was conducted to measure which location produced more energy per week. For 45 weeks, using the same number of panels, each site recorded the amount of energy (in kilowatts) it produced. The data from Site A and Site B are: The data from Site A and Site B are: Site A Site B 474 501 487 498 492 508 492 502 498 514 495 491 504 490 497 493 511 495 499 496 486 502 488 498 492 508 492 503 500 515 495 491 505 491 497 494 511 496 499 496 489 502 489 498 494 509 492 503 501 517 495 491 506 491 497 494 512 498 499 496 490 504 489 498 494 509 492 505 501 519 495 492 507 491 497 494 513 498 501 496 490 504 489 499 494 510 493 506 528 496 A.) Using Excel, create a histogram for both Site A and Site B with the appropriate scales to make meaningful comparisons. B.) Calculate the mean, median, mode, range, variance and standard deviation for each site. (Hint: Excel has a descriptive analysis tool). C.) Compute the 90th, 80th, and 70th percentiles for each site. D.) Are the mean values for Site A and Site B representative of the amount of energy produced in each site? In either site, were there any outliers that may have significantly affected the mean value? E.) Compare the amount of energy produced in Site A to Site B. Which site statistically performed better? F.) Write a professional memo to your boss recommending either Site A or Site B as the location of their solar powered project. Support your recommendation with statistics and explain the logic behind your reasoning