The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification 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.

Answers

Answer 1

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


Related Questions

Find the slope of the line graphed below.

Find the slope of the line graphed below.

Answers

Answer:

m=4/3

Step-by-step explanation:

slope=rise/run or y=mx+b

rise/run=8/6=4/3

How can you find 50% of any numbers

Answers

Answer:

Divide it by two

Step-by-step explanation:

Divide it by two

Answer:

you have to divide the numbers by 2

Here are the shopping times (in minutes) of ten shoppers at a local grocery store.
Complete the grouped frequency distribution for the data.
In the distribution, the frequency of a class is the number of shopping times in that class.
(Note that we are using a class width of 5.)

Here are the shopping times (in minutes) of ten shoppers at a local grocery store.Complete the grouped

Answers

The frequency which is to filled in the table is 1, 4, 2 and 4.

Given that;

All shopping time of ten shopkeeper:

25, 29, 25, 18, 24, 28, 36, 25, 33, 37

We have to complete the frequency in the table. Frequency of something is the number of times that number is coming.

Since, Shopping time is given as ,

25, 29, 25, 18, 24, 28, 36, 25, 33, 37

And, Intervals for which frequency is given is ,

18 to 22, 23 to 27, 28 to 32, 33 to 37.

Hence, WE get;

Numbers in the range 18 to 22 = 18  therefore 1

Numbers in the range 23 to 27 = 25, 25, 24, 25 therefore 4

Numbers in the range 28 to 32 = 29, 28  therefore 2

Numbers in the range 33 to 37 = 36, 33, 37,  therefore 3

Hence, the frequency which is to filled are 1, 4, 2 and 4.

Learn more about frequency visit:

brainly.com/question/254161

#SPJ1

HELP ASAP!!

Mr. Washington has a sign that is in the shape of a trapezoid. Some of the dimensions of the sign are shown. What is the area of Mr. Washington’s sign?

A) 24 sq. Ft.
B) 36 sq. Ft.
C) 42 sq. Ft.
D) 48 sq. Ft.

HELP ASAP!!Mr. Washington has a sign that is in the shape of a trapezoid. Some of the dimensions of the

Answers

Answer:

Answer shown from explanation

Step-by-step explanation:

Area of trapezium =1/2 * sum of parallel side * height = 1/2. *(6+12) *4= 36sqft

What is the third step in sketching the graph of a rational function

Answers

Answer:

use test numbers to find where the function is a positive and where it is negative. sketch the function's graph, plotting additional points as guides as negative. choose test numbers to t the left and right of each of these places, and find the value of the function at each test number.

Using the unpaid balance method, find the current months finance charge on a credit card account having the following transactions.
Last month’s balance: $385
Last payment: $250
Annual interest rate: 21%
Purchases: $303
Returns: $158
(It would be great if you could tell me how to use the formula I=Prt where previous months balance + finance charge + purchases made - returns - payments)

Answers

Answer:

$5.02

Step-by-step explanation:

The unpaid balance method is a common method used by credit card companies to calculate finance charges. It determines the finance charge based on a portion of the previous balance you have not yet paid.

Equations to use:

\(\boxed{\begin{minipage}{9.7cm}\phantom{w}\\Periodic (monthly) rate = annual interest rate $\div$ 12\\\\Finance Charge = previous balance $\times$ periodic rate\\\\Unpaid Balance = previous balance + finance charge +\\\phantom{wwwwwwwwwww} new purchases - returns - payments\\\end{minipage}}\)

The periodic rate is the interest rate charged over a certain number of time periods. The interest on a credit card is usually calculated monthly, so if the annual interest rate is 21%, then the periodic (monthly) rate is:

\(\text{Periodic Rate}=\dfrac{21\%}{12}=1.75\%=0.0175\)

The unpaid balance is "last month's balance", which is $385.

Calculate the finance change by multiplying the previous balance (last month's balance) by the periodic rate:

\(\begin{aligned}\text{Finance change} &=\rm previous\; balance \times periodic\;rate \\&=\$385 \times 0.0175 \\&= \$6.7375\end{aligned}\)

Calculate the unpaid balance by subtracting the returns and payments from the sum of the previous balance, finance charge and new purchases:

\(\begin{aligned}\rm Unpaid \; Balance &= \rm previous\; balance + finance\;charge +new \;purchases\\&\phantom{=w}\rm - returns - payments\\&= \$385 + \$6.7375 + \$303 - \$158 - \$250 \\&= \$286.7375\end{aligned}\)

Finally, to calculate the current month's finance charge, multiply the unpaid balance by the periodic rate:

\(\begin{aligned}\text{Current month's finance charge}&=\rm unpaid \;balance\times periodic \;rate\\&=\$286.7375 \times 0.0175 \\&= \$5.02\; \text{(nearest cent)}\end{aligned}\)

Therefore, the current month's finance charge is $5.02 to the nearest cent.

What can be used in order to convey things to players on the screen without using a lot of text or taking up a lot of screen space?
Group of answer choices

symbols

acronyms

pneumonic devices

homonyms

Answers

Answer:

the answer is actonums

Step-by-step explanation:

this helpfull : )

Answer:

acronyms

Step-by-step explanation:

how many solutions does this equation have –9q − 6 = –9q + 5

Answers

Answer:

Zero because it is in a form of -6 =5, which is not true.

Step-by-step explanation:

10.8.8 Check Your Understanding
Allison went on a business trip and stayed at a hotel for three nights. She paid a total of $782.07 for the room and to
park her car. Each night, the hotel charged d dollars and $17.20 for parking. Which equation represents the total
amount, in dollars, Allison paid for the three nights?
A) d+3(17.20) = 782.07
(B) 3d+17.20 = 782.07
C) 3(d-17.20) = 782.07
D) 3(d+17.20) = 782.07

10.8.8 Check Your UnderstandingAllison went on a business trip and stayed at a hotel for three nights.

Answers

We can see that the correct equation that can depict the problem is 3(d+17.20) = 782.07. Option D

Which equation shows the total charge?

We have to look at the problem that we have here. In the case of the question that we have been asked, we can see that for the problem that has been given here, it is clear that; Allison went on a business trip and stayed at a hotel for three nights. She paid a total of $782.07 for the room and to park her car.

If it is known that Each night, the hotel charged d dollars and $17.20 for parking. We can say that let the amount that is charged for the lodging be d and we have the equation as; 3(d+17.20) = 782.07.

Learn more about equation:https://brainly.com/question/29657983

#SPJ1

PLEASE HELP 50 POINTS!!
The sum of two consecutive numbers is 157. This equation, where n is the first number, represents the situation:
2n + 1 = 157.
What is the first number?
A. 77
B. 78
C. 79
D. 80

Answers

If a supposed number is n (say) then the consecutive number is n+1
If u add them n+(n+1) you get 157
So,
n+n+1=157
2n=156
n=78

Solve the proportion
8/3 = g/3

Answers

Answer:

g=8

that is

I hope to be helpful

I NEED HELP ASAP WHOEVER ANSWERS GETS BRAINLIST

I NEED HELP ASAP WHOEVER ANSWERS GETS BRAINLIST

Answers

The side length of the cube is 1/6 and the volume is 1/216

How to determine the side length of the cube

From the question, we have the following parameters that can be used in our computation:

Face area = 1/36

This means that

Side length = √(1/36)

Evaluate

Side length = 1/6

How to determine the volue of the cube

From the question, we have the following parameters that can be used in our computation:

Side length = 1/6

This means that

Volume = (1/6)^3

Evaluate

Volume = 1/216

Read more about volume at

https://brainly.com/question/463363

#SPJ1

show that cos4(t)+4cos2(t)=8cos^4(t)-3​

Answers

Explanation:

You want to show cos(4t) +4cos(2t) = 8cos⁴(t).

Double-angle identity

Use the cosine double-angle identity:

  cos(2t) = cos²(t) -sin²(t) = cos²(t) -(1 -cos²(t)) = 2cos²(t) -1

Then

  cos(4t) = 2cos²(2t) -1 = 2(2cos²(t) -1)² -1 = 2(4cos⁴(t) -4cos²(t) +1) -1

  = 8cos⁴(t) -8cos²(t) +1

Application

Substituting these expressions into the left side of the identity of interest, we have ...

  cos(4t) +4cos(2t) = 8cos⁴(t) -3 . . . . . . . . . . . . . . . . . . identity to prove

  (8cos⁴(t) -8cos²(t) +1) +4(2cos²(t) -1) = 8cos⁴(t) -3 . . . substitute

  8cos⁴(t) -8cos²(t) +1 +8cos²(t) -4 = 8cos⁴(t) -3 . . . . . eliminate parentheses

  8cos⁴(t) -3 = 8cos⁴(t) -3 . . . . . . combine like terms; Q.E.D.

Multiply (9 − 4i)(2 + 5i).

Answers

Answer:

38 + 37i

Step-by-step explanation:

(9 − 4i)(2 + 5i)

FOIL

first: 9*2 = 18

Outer: 9*5i = 45i

inner: -4i * 2 = -8i

last : -4i * 5i = -20i^2 = -20(-1) = 20

Combine together

18+45i-8i +20

38 + 37i

Answer:

38+37i

Step-by-step explanation:

(9 − 4i)(2 + 5i)= 18+45i-8i-20i²= 18+20+37i= 38+37i

Answer the questions below to find the total surface area of the can.

Answer the questions below to find the total surface area of the can.

Answers

Ab=3.14xRadious to the power of 2

then to the area of the rectange you do B x H = YOUR ANSWER

Victoria and Georgetown are 36.2 mi from each other. How far apart would the cities be on a map that has a scale of 0.9 in 10.5 mi?

Answers

Answer:0.9 * (36.2/10.5) = 3.1 in

Step-by-step explanation:

I got an A <3

In quadrilateral BADC, AB=AD and BC=DC. The line AC is a line of symmetry for this quadrilateral.

Quadrilateral B A D C.

a. Based on the line of symmetry, explain why the diagonals AC and BD are perpendicular.

Answers

9514 1404 393

Answer:

  a line of symmetry is always the perpendicular bisector of a point and its symmetrical image

Step-by-step explanation:

A line of symmetry is a perpendicular bisector of any segment joining a point and its symmetrical image. B and D are symmetrically located about line AC, so AC must be a perpendicular bisector of BD.

Julio tiene 12 años de edad y su padre tiene 42 años. ¿Cuántos años tendrá Julio cuando su padre tenga el doble de su edad?

Answers

Julio will be 30 years old when his father is twice his age.

To determine the age at which Julio will be twice his father's age, we need to find the age difference between them and then add that difference to Julio's current age.

Currently, Julio is 12 years old, and his father is 42 years old. The age difference between them is 42 - 12 = 30 years.

For Julio to be twice his father's age, the age difference needs to remain the same as it is currently. Therefore, when Julio is x years old, his father will be x + 30 years old.

Setting up an equation to solve for x:

x + 30 = 2x

Simplifying the equation, we subtract x from both sides:

30 = x

Thus, when Julio is 30 years old, his father will be 30 + 30 = 60 years old. At this point, Julio will indeed be twice his father's age.

Therefore, Julio will be 30 years old when his father is twice his age.

Note : the translated question is Julio is 12 years old and his father is 42 years old. How old will Julio be when his father is twice his age?

For more such question on age. visit :

https://brainly.com/question/30994122

#SPJ8

PLEASE TELL ME THE ANSWER TO ALL I WILL GIVE BRAINLIEST PLEASE

PLEASE TELL ME THE ANSWER TO ALL I WILL GIVE BRAINLIEST PLEASE

Answers

First one
————————————————————-
PLEASE TELL ME THE ANSWER TO ALL I WILL GIVE BRAINLIEST PLEASE

Which is the correct point slope form of the equation for the line that contains the
points (4,5) and (7,-7)?

Answers

(5,6)

Explanation: just answered it on test

(Translate each sentence into a formula)
the area A of a circle is pi times the radius r squared

Answers

Answer:

A=πr2

THIS IS THE ANSWER

PLEASE MARK BRAINLIEST!!!!!

yo whats i lowkey cant think rn 3/4 times 2 ??

Answers

6/4 or 1 and 2/4 thats a pretty easy question

Answer:

1.5 in a decimal

Step-by-step explanation:

i hope it helps

The hours a week people spend answering and sending emails is normally distributed with a standard deviation of Ï = 150 minutes. How large of a sample size would you need to estimate the mean number of minutes people spend answering and sending emails with an error of 1 minutes with 99% confidence? What would be the practical problem with attempting to find this confidence interval?

Answers

Answer:

sample size n would be 149305 large

Value of n (149305) is too high, this will be the practical problem with attempting to find this confidence interval

Step-by-step explanation:

Given that;

standard deviation α = 150 min

confidence interval = 99%

since; p( -2.576 < z < 2.576) = 0.99

so z-value for 99% CI is 2.576

E = 1 minutes

Therefore

n = [(z × α) / E ]²

so we substitute

n = [(2.576 × 150) / 1 ]²

n = [ 386.4 ]²

n = 149304.96 ≈ 149305

Therefore sample size would be 149305 large

Value of n is too high, that would be the practical problem with attempting to find this confidence interval

In 2005, 10^10 text messages were sent in the United States. In
2010, the number of annual text messages had risen to 10^12
The number of text messages for 2010 was how many times the
number of text messages for 2005?

Answers

9514 1404 393

Answer:

  100

Step-by-step explanation:

The ratio of the numbers for the two years is ...

  (10^12)/(10^10) = 10^(12-10) = 10^2 = 100

In 2010 there were 100 times as many text messages as in 2005.

Question 10 of 10
Check all that apply. If tane = 15/8,then:
A. csco =17/15
B. sece =17/8
C. cose =15/17
D. cote =8/15

Question 10 of 10Check all that apply. If tane = 15/8,then:A. csco =17/15B. sece =17/8C. cose =15/17D.

Answers

If tan Ф = 15/8 then we have these trigonometric functions cosec Ф = 17/15, sec Ф = 17/8 and cot Ф = 8/15.

According to the question,

We have the following information:

Tan Ф = 15/8

We know that in this trigonometric function we have perpendicular divided by base.

Now, we can find the hypotenuse using the Pythagoras theorem:

Let's denote hypotenuse with h, perpendicular with p and base with b.

\(h^{2} =p^{2} +b^{2}\)

\(h^{2}\) = \((15)^{2} +(8)^{2}\)

\(h^{2} = 225+64\\h^{2} = 289\\h = \sqrt{289}\)

h = 17 units

Now, we have the following values:

Cosec Ф = 17/15 (Hypotenuse/perpendicular)

Sec Ф = 17/8 (h/b)

Cos Ф = 8/17 (b/h)

Cot Ф = 8/15 (b/p)

Hence, the correct options are A, B and D.

To know more about trigonometric functions here

https://brainly.com/question/14434745

#SPJ1

PLEASE HELP!
Solve for x: 1 < x + 3 < 4
4 > x > 7
4 < x < 7
−2 > x > 1
−2 < x < 1

Answers

Answer:

the last choice

Step-by-step explanation:

u will minus 3 from each side. that's the point

A sample was done, collecting the data below. Calculate the standard deviation, to one decimal place.

x
14
9
7
1
23

Answers

Answer:

Standard Deviation = 7.4

Standard Deviation:

Standard deviation (denoted by symbol: σ ) is a measure of how dispersed or spread out the data is in relation to the mean. i.e, by how much the data deviates from the mean. A low standard deviation represents a sample that has its data clustered around the mean, and a high standard deviation represents indicates the data is more dispersed.

There are two primary ways of calculating the standard deviation. One is with the calculator, which will depend on what model/brand you use. The other method involves the formula for standard deviation:

\(\boxed{\sigma = \sqrt{\frac{\Sigma (x-\mu)^2}{N}}}\)

σ = standard deviationN = total number of data\(\bold{x}\) = each scores\(\bold{\mu}\) = mean of scoresΣ = "sum of"

\(\begin{tabular}{c | c | c }x & \math{(x - \mu)} & \math{(x-\mu)^2} \\\cline{1-3}1 & -9.8 & 96.04\\7 & -3.8 & 14.44\\9 & -1.8 & 3.24\\14 & 3.2 & 10.24\\23 & 12.2 & 148.84\\\end{tabular}\\\\\mu = 10.8\\\Sigma(x-\mu)^2 = 272.8 \\ N=5\)

Now we have all the information we require, we can input values into the formula:

\(\sigma = \sqrt{\frac{272.8}{5}} = 7.38647... \approx 7.4\)

To learn more about standard deviation:

https://brainly.com/question/29138469

Which of the following is an example of a rational number?

Which of the following is an example of a rational number?

Answers

I’m sure it is b
Please give me a thanks I would really appreciate it

h is a trigonometric function of the form h(x)=a sin(bx+c)+d. Below is the graph h(x). The function intersects its midline at (-pi,-8) and has a maximum point at (pi/4, "-1.5)." Find a formula for h(x). Give an exact expression.

Answers

Answer:

6.5sin(.04x+.4pi)-8

The function intersects its midline at (-pi,-8) and has a maximum point at (pi/4, "-1.5). The  final equation is h(x) = 4 sin(2x +  π /2) + 3.

What is a function?

A function is defined as a relation between the set of inputs having exactly one output each.

The function intersects its midline at (3π/4, 3) then the midline is d= 3.

The amplitude is just the positive distance between the maximum/minimum and the midline,

so the amplitude a = 7 - 3 = 4

Also, given that period is 2π/b and the fact that the period is π from our given maximum,

we have the equation 2π/b= π where b = 2

we know that the phase shift, -c/b is - π/4 (or  to the left)

since -π /4. Therefore, c = π /2.

our final equation is

h(x) = 4 sin(2x +  π /2) + 3.

Learn more about function;

https://brainly.com/question/23483920

#SPJ2

Pythagorean triples are given by these formulas:
(2²-37, 2zy, z²+37²)
The hypotenuse of a right triangle is 29. The lengths of the legs are whole numbers. List your answers in increasing
order.
The lengths of the two legs are
and

Pythagorean triples are given by these formulas:(2-37, 2zy, z+37)The hypotenuse of a right triangle is

Answers

The lengths of the two legs of the right triangle are 58 and 839, in increasing order.

We have,

The formula given is incorrect.

The correct formula for Pythagorean triples with a given integer z is:

(z² - 1², 2z, z² + 1²)

Using this formula, we can find the two legs of the right triangle with hypotenuse 29 as follows:

z² + 1² = 29²

z² + 1 = 29²

z² = 29² - 1

z² = 840

z = √840

z = 28.98

Since z must be an integer, we can try integer values close to 28.98 to find one that works.

Trying z = 29,

a = z² - 1² = 840 - 1 = 839

b = 2z = 58

c = z² + 1² = 840 + 1 = 841

Therefore,

The lengths of the two legs of the right triangle are 58 and 839, in increasing order.

Learn more about the right triangle here:

https://brainly.com/question/14930619

#SPJ1

Other Questions
What is Biomass? Account for the types of energy from biomass. FOR 10 POINTSIn the word disappearing, the prefix isdisadidisand the suffix isingaring match the description to the term. 1. attempts to convince coherence 2. parts fit together in a unified whole descriptive 3. explanatory type of writing analytical 4. use of examples, definition, detail, or comparison organization 5. succinct concise 6. a type of writing which breaks down a process or situation into its parts clarity 7. clearness illustrative pattern 8. giving a picture of something in words argumentative 9. manner of development or overall plan of an essay or nonfiction writing dominant mood 10. cheerfulness, sadness, or nostalgia expository Fill in the blank to complete the trigonometric formula.. sin 2u = How do you think the nobles feel about the increasing power of the monarchy? Why? North Jetty Manufacturing makes windows and doors for local building contractors. Several of North Jettys workers have received new PCs in recent weeks, and they need your advice about how to deal with the problems described below:1. Jose Fonseca, production schedulerThe desk space for Joes workstation is very limited. ayudaaaaaaaaaaaaaaaaa The reference to "barriers which separate Muslims and Hindus" in the excerpt most directly refers to which of the following?A. The increase in Islamic military expansion campaigns under the Turkish peopleB. The cultural tension between followers of strict monotheism and rituals polytheismC. The difference in the role of women between society thought out the Islamic worldD. The enforcement of special taxes placed on non-Muslim 4.)Given ZBAM is a right angle and mZBAM = 4x + 22,determine the value of x. Enter the NUMBER only.Do NOT put x = . It will mark it wrong.Your answerI geographyplease answer quicklyWhat is an atmospheric window and how does it impact Earth's radiation budget. which environmental group is most closely associated with mountain climbing, backpacking, and camping? If brown bread was described as "food for left wing people", what made it become mainstream in the supermarket ecosystem? Do you think Bill Clinton deserved to be Impeached? Approximately how many different handshapes are used in asl?. The measures of two angles are 4x and (2x + 12). What must be true if x = 13 A. The angles are vertical. B. The angles are equal. C. The angles are complementary. D. The angles are supplementary. Reread the second verse of the poem Fear": "The cold black fear is clutching me to-night."What figure of speech does it contain? Suppose you are asked to pick 4 numbers from 1 to 20 to win a prize. What is the probability that one of the numbers you will pick is the winning number? giving brainliest and 20 points! please solve this. :D Sodium chloride is written as NaCl and is composed of one sodium ion and one chloride ion. Calcium chloride is written as CaCl2 and is composed of one calcium ion and two chloride ions. How do you know that two chloride ions are required to make calcium chloride (you may use a LDD for the ionic bond between calcium and chlorine or write it out in words)? Suppose that McDonalds and Yum Brands are the sole producers of a quadruple-decker chicken and hamburger sandwich. The two firms currently charge the same price for their products. If neither form reduces the price of its quadruple-decker chicken and hamburger sandwich, each firm earns $40 million in profit. If both firms reduce their prices, then each firm will earn $10 million in profit. If one firm reduces its price and the other does not, then the firm that reduces price will earn a profit of $60 million while the other firm will earn a profit of $2 million Assuming that collusion is not a possibility, the Nash equilibrium occurs when Choose one: O A. Yum Brands will reduce its price and McDonalds will maintain its current price. O B. both forms will reduce their price. OC. McDonalds will reduce its price and Yum Brands will maintain its current price. OD. both forms will maintain their current price.