Ch14+Homework

xlsx

School

Northern Virginia Community College *

*We aren’t endorsed by this school

Course

121

Subject

Mathematics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by GrandTurkeyMaster1050

Year Quarter Winery Appellation Cost Per Case Cases Sold Sales 1991 Q1 Beaulieu Cabernet Sauvignon $165 450 1991 Q2 Beaulieu Cabernet Sauvignon $165 550 1991 Q3 Beaulieu Cabernet Sauvignon $165 575 1991 Q4 Beaulieu Cabernet Sauvignon $165 650 1992 Q1 Beaulieu Cabernet Sauvignon $165 310 1992 Q2 Beaulieu Cabernet Sauvignon $165 625 1992 Q2 Beaulieu Cabernet Sauvignon $165 314 1992 Q4 Beaulieu Cabernet Sauvignon $165 670 1991 Q1 Beaulieu Chardonnay $163 230 1991 Q2 Beaulieu Chardonnay $163 425 1991 Q3 Beaulieu Chardonnay $163 460 1991 Q4 Beaulieu Chardonnay $163 450 1992 Q1 Beaulieu Chardonnay $163 170 1992 Q1 Beaulieu Chardonnay $163 230 1992 Q2 Beaulieu Chardonnay $163 175 1992 Q2 Beaulieu Chardonnay $163 232 1992 Q3 Beaulieu Chardonnay $163 208 1992 Q3 Beaulieu Chardonnay $163 180 1992 Q3 Beaulieu Chardonnay $163 219 1992 Q4 Beaulieu Chardonnay $163 220 1992 Q4 Beaulieu Chardonnay $163 175 1992 Q4 Beaulieu Chardonnay $163 225 1991 Q1 Beaulieu Merlot $160 180 1991 Q1 Beaulieu Merlot $160 320 1991 Q2 Beaulieu Merlot $160 325 1991 Q2 Beaulieu Merlot $160 190 1991 Q3 Beaulieu Merlot $160 195 1991 Q4 Beaulieu Merlot $160 200 1991 Q1 Duckhorn Merlot $148 275 1991 Q2 Duckhorn Merlot $148 660 1991 Q2 Duckhorn Merlot $148 481 1991 Q2 Duckhorn Merlot $148 280 1991 Q3 Duckhorn Merlot $148 485 1991 Q4 Duckhorn Merlot $148 499 Total

Discount Net 26.50% 30% Directions Determine the Sales amounts by multiplying the cost per case times the cases sold. If the cost per case is greater than or equal to $160, the Disco is 26.5% (cell K3) times the sale. Otherwise the Discount is 30 (cell K4) times sales . Be sure to use an absolute reference in t formula (for K3 and K4) Determine the Net by subtracting the discount from the Sales Determine the Totals fo the columns F, G, H and I.

e ount 0% the s.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Dress Color Count Dress Size Count Shoe size Count Color Count Blue 83 0 12 5 9 Silver 161 Black 44 2 26 5.5 9 Black 72 Purple 41 4 24 6 16 Gold 56 Pink 36 6 29 6.5 22 Pink 7 Red 17 8 27 7 37 White 8 White 21 10 26 7.5 27 Purple 4 Coral 15 12 35 8 57 Red 3 Aqua 12 14 30 8.5 33 Blue 2 Green 26 16 34 9 35 Orange 6 18 24 9.5 19 Yellow 7 20 16 10 31 Rainbow 5 22 13 10.5 3 24 10 11 12 26 2 12 3 28 5 Total = 313 Total = 313 Total = 313 Total = 313 Directions Create a v "Dress Cou graph app Create a v "Shoe Cou graph app Create a P insert a co toal (use a Create a P insert a co toal (use a

s vertical bar graph with "Dress Size" on the x-axis and unt" on the y-axis. Be sure to label each axis and the propriately. vertical bar graph with "Shoe Size" on the x-axis and unt" on the y-axis. Be sure to label each axis and the propriately. Pie graph with using "Dress Color". You will need to first olumn to calculate the percentage of each color with the a formula). Pie graph with using "Shoe Color". You will need to first olumn to calculate the percentage of each color with the a formula).

Applied Calculus Basic Math Days Missed Final Grade Days Missed Final Grade 15 68% 14 46% 2 92% 10 90% 7 76% 10 69% 5 82% 13 74% 11 64% 40 27% 4 98% 2 103% 17 20% 29 45% 5 93% 4 91% 0 93% 1 91% 7 74% 22 56% 12 69% 12 56% 17 10% 35 37% 4 85% 13 81% 6 81% 12 71% 5 88% 7 82% 9 90% 12 88% 38 8% 30 0% 0 90% 8 87% 4 96% 2 96% 16 40% 14 45% 8 75% 19 59% 2 96% 3 97% 0 97% 3 97% 0 92% 5 90% 13 55% 25 5% 2 90% 12 87% 10 58% 25 10% 1 90% 5 86% 3 91% 10 88% 1 94% 1 93% 1 103% 2 105% 13 63% 30 17% 8 94% 7 92% 5 82% 9 75% 6 82% 10 80% 1 94% 5 96% 6 76% 23 64% 4 89% 16 83% 1 89% 11 84% 14 44% 29 3% 4 82% 7 74% Directions Create a x-y scatter gr math. The x-axis shou Appropriately label ea Create a Trendline for

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

13 68% 18 52% 3 84% 2 81% 15 63% 23 19%

raph with two lines. One for Applied Calculus and another for Basic uld represent Days Missed. The y-axis should represend Final Grade. ach series, axis, and graph. r each line. Be sur to display the equation and the R 2 value.

Ch14+Homework

Related Documents