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:
two dots: (0, -7), (1, -3)
and it's the line
Step-by-step explanation:
just try x=0, g(x)=-7
and x=1, g(x)=-3
Hey,
The lower quartile is the median of the lower half of the data set.
The median is the middle most number or the average of the two middle most numbers depending on how many values there are.
Cheers,
Izzy
Answer:
P in terms of V is:
P = 432/V
Step-by-step explanation:
We know that y varies inversely as x, we get the equation
y ∝ 1/x
y = k/x
k = yx
where k is called the constant of proportionality.
In our case,
P is inversely proportional to V
Given
P = 18
V = 24
so
P = k/V
k = PV
substituting P = 18 and V = 24 to determine k
k = 18 × 24
k = 432
now substituting k = 432 in P = k/V
P = 432/V
Therefore, P in terms of V is:
P = 432/V
A. 0, 7 is your answer
hope this helps
