Step-by-step explanation:
Absolute error = 300-286
=14 pounds
Percentage error = 14/286 x 100%
=4.8951
=4.9%
Answer:
We make scatterplots to see relationships between variables. Scatterplots are really good for helping us see if two variables have positive or negative association (or no association at all).Step-by-step explanation:
Answer:
52 tickets cost $10 and 18 tickets cost $12
Step-by-step explanation:
10x+12y=804. (1)
x+y=70. (2)
From (2)
x=70-y
Substitute x=70-y into (1)
10x+12y=804
10(70-y)+12y=804
700-10y+12y=804
700+2y=804
2y=804-700
2y=104
y=104/2
y=52
Recall
x+y=70
x+52=70
x=70-52
x=18
52 tickets cost $10 and 18 tickets cost $12
Answer:
Total sales revenue use excel function : ( SUMIF. =sumif(range, criteria, [sum_range] )
For each of the stores: Use excel function: For Store 1: =sumif(B4:B99,1,I4:I99) then repeat same for Store 2 to store 8
Step-by-step explanation:
To modify the spreadsheet to calculate the total sales revenue we will add a column " sales revenue "
multiply values of column : ( unit sold * unit price ) to get Total sales revenue. then use excel function : ( SUMIF. =sumif(range, criteria, [sum_range] ) to find Total sales revenue
calculate the total revenue for each of the 8 stores using a pivot table using "store identification number" in row and " sales revenue " in values field
To get the sales revenue ; replace " store identification value" with sales region " column
