Question

Basic Tools Exercise - Excel Search A simran rajbhandari SR х AutoSave On HUB File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments AutoSum Calib AA a wrap Text General SEX 47 4 Hill Waste [Copy Format Painter BTU Insert Delete Format Ideas ES + Merge & Center $ - % 4000 000 Conditional Format as Cell Formatting Table Styles Clear Sort & Find & Filter v Select Editing cipboard Fort Alignment Number Style: Cels Ideas A CS fi M N 0 P Q R S T U w - A R c. F F G H K 1 You are trying to determine if there is a relationship between outside temperature and ice cream sales. 2 Make a scatter plot and add a trend line and r-squared values to determine the strength and direction of the relationship. 3 E 16.4 Ice Cream Sales ($) 700 GOO y - 30.DARX - 159.47 R-0.9158 500 401 300 4 Temperatu Ice Cream Sales (S) 5 14. 215 6 325 7 11.9 185 8 15.2 332 9 18.5 406 10 22.1 522 11 19.4 412 12 25.1 614 13 23.4 544 14 18.1 421 15 22.6 445 16 17.2 40B 17 18 19 20 21 22 23 24 25 26 27 23 29 Pareto chart Pareto 200 100 a 0 5 10 15 20 25 30 Scatterplot Check Sheet Control Chart I listogram Cause and Cllect Diagam Flow Ch... . Reed 1005

Answer 1

Solution:

1: Scatter Plot

y = 30.088x - 159.47 R2 = 0.9168 Scatter Plot 700 600 500 400 Ice Cream Sales 300 200 100 0 0 5 10 15 20 25 30 Temperature

The strength of the relationship between the temperature outside and the ice cream sales is a strong positive.

2: Histogram:

Histogram Ice cream sales 8 7 7 6 5 4 Month 2 1 1 0 (185, 375] (565, 755] (375, 565) Ice Cream Sales

Overall Solution:

Histogram Ice cream sales 8 Ice cream sales 215 325 185 332 406 522 412 614 7 7 6 5 4 Month 3 544 2 1 421 445 1 0 408 [185, 375] (565, 755] (375, 565] Ice Cream Sales Temperature 14.2 y = 30.088x - 159.47 R2 = 0.9168 Scatter Plot 16.4 700 600 Ice cream sales 215 325 185 332 406 522 412 614 544 11.9 15.2 18.5 22.1 19.4 25.1 23.4 500 400 Ice Cream Sales 300 200 18.1 421 22.6 100 445 408 17.2 0 O Сл 10 15 20 25 30 Temperature

**Can solve only the first question in a group of unrelated questions as per HOMEWORKLIB POLICY**