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
Answer:the z score is - 1
Step-by-step explanation:
Assuming a normal distribution for the delivery time of sandwiches by Sammy's Sandwich Shop. We would apply the formula for normal distribution which is expressed as
z = (x - u)/s
Where
x = delivery times
u = mean delivery time
s = standard deviation
From the information given,
u = 25 minutes
s = 2 minutes
We want to determine the z-score for the number of sandwiches delivered in less than 23 minutes. It becomes
z = (23 - 25)/2 = - 1
Answer:
x= -1
Step-by-step explanation:
Solving through linear equation,
-0.1x + 3/10= 4/10
Bring 3/10 to the other side making it minus
-0.1x = 4/10 - 3/10
-0.1x = (4-3)/10
-0.1x= 1/10
Bring -0.1 to the other side n divide
x= 1/10 ÷ -0.1
( Note that -0.1 is the same as -1/10)
x = 1/10 ÷ -1/10
= 1/10*-10/1
= -10/10
= -1
The length of side walk is 500 feet
<em><u>Solution:</u></em>
Given that, A rectangle park measures 300 ft by 400 ft
Length = 300 feet
Width = 400 feet
A sidewalk runs diagonally from one comer to the opposite corner
We have to find the length of side walk
Which means, we have to find the length of diagonal of rectangle
<em><u>The diagonal of rectangle is given by formula:</u></em>
Where,
d is the length of diagonal
w is the width and l is the length of rectangle
<em><u>Substituting the values in formula, we get</u></em>
Thus length of side walk is 500 feet
