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.

Number of Number of Number of Number of Number of Daily Male Visitors [Female Visitors Retail Stands Food Stands Performances Revenue (5) G 1,200 1,600 1,200 1,400 1,400 1.800 1.300 1,300 1,300 16 15 20 21 800 2.300 1,400 1.800 1,700 1,600 1,300 1,900 2,200 2.100 1,500 1,900 500 1.200 1,600 1,000 1,800 2.000 1,500 1,300 1,500 2,200 1,700 1,400 2.000 2,300 1,200 1.900 1,600 2.100 1,900 300 1.000 1,900 1,800 1,600 2.000 1,600 2,500 1.700 1,600 1,600 1,200 1,300 1,200 1,200 1,200 1,500 1,200 1,200 1,900 1,200 1,400 1,200 1.700 1,400 1,300 1.800 1,800 1,800 1.800 900 1.200 1,600 1,400 1,200 1.800 1,600 1.500 F 56,841 599,393 $47.412 $44,022 $59,683 572,313 $50,283 $89,669 $95.977 $67,021 $88.410 $89,167 $25,905 $8,069 $56,290 $12.788 $26,851 $57,095 $22,326 $37,061 $78,095 $75,473 $71,226 $30,830 $91,625 $99, 150 $36,384 $87.934 $86.703 $81,527 585,347 $7,198 $12.463 $84.980 $59,411 $81,787 587,651 565,347 $98,349 33 33 30 39 19 35 31 35 20