Using the Beverage Sales dataset, define the name temp for the range of the Temperature data and the name sales for the range of the Sales data. Then, use these range names in Excel formulas to find the median, min and max for each of the two variables

 

Beverage Sales Temperature Sales 85 90 79 82 84 96 88 76 93 97 89 83 85 90 82 91 90 84 79 81 95 $1,810 $4,825 $ 438 $ 775 $1,213 $8,692 $2,356 $ 266 $4,930 $9,138 $2,714 $1,082 $1,290 $3,970 $ 894 $2,906 $4,615 $1,168 $ 462 $1,018 $5,950