1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Liula [17]
3 years ago
9

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identificat

ion number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year.2 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions.
Mathematics
1 answer:
zhannawk [14.2K]3 years ago
8 0

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

You might be interested in
Please sketch graph of the function f(x) = |x+2|.
Burka [1]

Answer:

The absolute value can be graphed using the points around the vertex (-2, 0), (-4, 2), (-3, 1), (-1, 1), (0, 2).

Step-by-step explanation:

The find the x coordinate of the vertex, set the inside of the absolute value x + 2 equal to 0. In this case, x + 2 = 0.

x + 2 = 0

Subtract 2 from both sides of the equation.

x = -2

Replace the variable x with -2 in the expression.

y = |(-2) + 2|

The absolute value vertex is (-2, 0).

The domain of the expression is all real numbers except where the expression is undefined. In this case, there is no real number that makes the expression undefined.

For each x value, there is on y value. Select few z values from the domain. It would be more useful to select the values so that they are around the x value of the absolute value vertex.

Substitute the x value -4 into f(x) = |x+2|. In this case, the point is (-4,2).

y=2

Substitute the x value -3 into f(x) = |x+2|. In this case, the point is (-3,1).

y=1

Substitute the x value 0 into f(x) = |x+2|. In this case, the point is (0,2).

y=2

You can find the graph in the attachment.

6 0
3 years ago
A bakery sells 4 dozen cupcakes every 3 hours. If the bakery is open 8 hours each day, how many days does it take to sell 640 cu
zmey [24]

5 days does it take to sell 640 cupcakes.

Given:

A bakery sells 4 dozen cupcakes every 3 hours.

If the bakery is open 8 hours each day.

4 dozen cupcakes = 4*12 cupcakes

= 48 cupcakes

48 cupcakes = 3 hours

divide by 3 on both sides

3hours/3 = 48/3 cupcakes

1 hour = 16 cupcakes

Number of cupcakes for 8 hours = 8 * 16 = 128 cupcakes.

128 cupcakes sells in one day.

To sell 640 cupcakes = 640/128

= 5 days.

Therefore 5 days does it take to sell 640 cupcakes.

Learn more about the bakery and cupcakes here:

brainly.com/question/14466478

#SPJ1

8 0
1 year ago
Which one of the following is considered a quantitative variable?
tatyana61 [14]
Okay so here's the definition of quantitative just in case you ever need it :) Categorical. Categorical variables take on values that are names or labels. The color of a ball (e.g., red, green, blue) or the breed of a dog (e.g., collie, shepherd, terrier) would be examples of categorical variables. And the answer would be A the color of your car because it talks about in the definition of the color of a ball so A would be the correct answer! Please mark brainliest :)
7 0
3 years ago
A fenced in rectangular region with the dimensions 4 yards by 8 yards is suddenly expanded by the same distance in each dimensio
Korolek [52]

Answer:

The distance added to each dimension is 2 yards.

Step-by-step explanation:

The initial dimensions of the rectangular fence is 8 yards by 4 yards.

The initial area of the rectangular fence = area of a rectangle

area of a rectangle = length x width

So that,

The initial area of the fence = 8 x 4

                                              = 32

The initial area of the fence is 32 square yards.

But, with the new dimensions, area = 60 square yards.

(4 + x) x (8 + x) = 60

x^{2} + 12x + 28 = 60

x^{2} + 12x - 32 = 0

(x + 14) = 0 or (x - 2) = 0

x = -14 or x =2

Thus, x = 2

The distance added to each dimension is 2 yards.

4 0
3 years ago
Kittens weigh about 100 grams when born and gain 7 to 15 grams per day.If a kitten weighed 100 grams at birth and gained 8 grams
natka813 [3]
100 + 8d = 300; d = 25; The kitten will triple its weight in 25 days
8 0
3 years ago
Read 2 more answers
Other questions:
  • I cannot figure out the work for this problem.
    9·1 answer
  • Expand and simplify <br><br> (× + 1)(×^2 + 2× +3)
    12·1 answer
  • What is 0.00000000472 estimated as the product of a single digit and a power of 10?
    7·2 answers
  • How many flowers spaced every 3 inches are needed to surround a circular garden with a 30 foot radius? Round all circumference a
    11·1 answer
  • What is 5/100 written as a decimal
    13·2 answers
  • Your store is purchasing vegetables for premade meals and you have two different companies to choose from. Company A charges $28
    5·1 answer
  • 1. Use the distributive property to simplify.<br> 3 (a – 2c)
    11·1 answer
  • What the the answer to 36 = 18x
    13·2 answers
  • Express as an improper fraction 13 ⅔<br>​
    13·2 answers
  • How do you graph <br>{x-y=6<br>3x+5y=10​
    14·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!