1 The spreadsheet below contains the data about daily revenue, the number of male visitors, the number of female visitors, the number of retail stands, the number of food stands, and the number of performances that the organizer used to create the regression model. The organizer now wants to try excluding the number of male visitors and the number of performances from the model because those variables were not significant. Create a regression model to analyze the relationship between daily revenue and the remaining independent variables. Be sure to include the residuals and residual plots in your analysis. ...Please write excel steps for this incuding formula, excel functions Number of Male Visitors Number of Female Visitors Number of Retail Stands Number of Food Stands Number of Performances Daily Revenue ($) 600 1,200 8 6 15 $6,841 2,300 1,600 30 15 35 $99,393 1,400 1,200 14 8 27 $47,412 1,800 1,400 13 12 35 $44,022 1,700 1,400 21 10 28 $59,683 1,600 1,600 30 13 29 $72,313 1,300 1,300 17 12 30 $50,283 1,900 1,300 29 13 33 $89,669 2,200 1,300 30 14 35 $95,977 2,100 1,700 17 14 28 $67,021 1,500 1,600 29 13 33 $88,416 1,900 1,600 27 14 31 $89,167 500 1,200 12 11 9 $25,905 1,200 1,300 8 8 20 $6,069 1,600 1,200 21 13 31 $56,290 1,000 1,200 9 9 17 $12,788 1,600 1,200 16 10 23 $26,851 2,000 1,500 15 11 29 $57,095 1,500 1,200 12 7 17 $22,326 1,300 1,200 17 11 25 $37,061 1,500 1,900 14 15 28 $78,095 2,200 1,200 26 13 33 $75,473 1,700 1,400 26 14 28 $71,226 1,400 1,200 15 11 28 $30,830 2,000 1,700 26 15 35 $91,625 2,300 1,400 28 15 35 $99,150 1,200 1,300 12 10 25 $36,384 1,900 1,600 28 13 35 $87,934 1,600 1,800 27 13 29 $86,703 2,100 1,800 18 13 34 $81,527 1,900 1,600 25 14 35 $85,347 300 900 4 5 7 $7,198 1,000 1,200 9 5 5 $12,463 1,900 1,600 24 15 34 $84,980 1,600 1,400 17 14 33 $59,411 1,600 1,200 28 14 32 $81,787 2,000 1,600 30 12 35 $87,651 1,600 1,600 19 11 31 $65,347 2,500 1,500 29 15 35 $98,349