Answer:
31.0
Step-by-step explanation:
The mean of a given set of data is the ratio of the sum of the data to the number of units that make up the data set. It is also called the average of the data set.
Given the data set {22, 34, 37, 23, 45, 21, 29, 37}. There are 8 numbers in the set. The total of these numbers
= 22 + 34 + 37 + 23 + 45 + 21 + 29 + 37
= 248
The mean = 248/8
= 31
Answer:
Answer in file:
Step-by-step explanation:
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
So product means multiplication so -2*(x-6) > -18 so divide by -2 on both sides to get x-6<9 because when you multiply a negative the sign swaps directions and then add 6 to get x<15
