Answers
9514 1404 393
Answer:
B7 formula: =AVERAGE(B3:B6)
B8 formula: =B1*B2*B7
Step-by-step explanation:
There are two parts to finding the answer to the questions posed. (1) You need to understand what you are being asked to calculate. (2) You need to know how to write that calculation as a spreadsheet formula.
It is beyond the scope of this answer to give a tutorial in spreadsheets. Many web sites, videos, books, and other help sources are available to teach you how to open and use a spreadsheet. Presumably, you've been given an introduction in your class.
_____
a) The problem statement tells you that cell B7 contains the average of the values in cells B3 to B6.
The AVERAGE function will compute the average of a range of cells. It can be used in cell B7 to compute the average of the values in cells B3 to B6. The formula would generally be written ...
=AVERAGE(B3:B6)
__
b) Problem 10 doesn't tell you explicitly what the pension formula is. We have to assume that it is similar to the formulas described in problems 8 and 9. That is, it is the product of a percentage, years worked, and the average of some number of salaries. In problem 10, the average is of 4 salaries.
The value in B8 will be the product of the pension credit percentage per year worked, the number of years worked, and the average of the last 4 years' salaries. Those values are in cells B1, B2, and B7, so the formula is written ...
= B1*B2*B7
_____
The attachment shows the spreadsheet with the numbers from problem 8. The formula bar shows the formula for the selected cell, B8.
Related Questions
Pls help me with math ASAP
Answers
This means their angles add up to 180° which is a straight line
Answer:
Its c
Step-by-step explanation:
15 POINTS!!!IF YOU HELP ME!!!
1. A shopper bought a 10-pound bag of apples for $12.50. What was the unit price? Show your work. A $0.63 C $6.25 B $1.25 D $12.50
Answers
I have 1 litre of water in a jug. On the way to my table I spill some. I have 780ml left. How much have I lost?
Answers
Step-by-step explanation:
1 litre = 1000ml
780ml left
lost amount = 1000 - 780 = 220ml
Simplify the rational expression by rationalizing the denominator √15/√6x
Answers
Answer:
√10/2x
Step-by-step explanation:
Multiply by √6 on the top and bottom to rationalize the denominator.
(√15×√6)/(√6x×√6) = √90/6x = (√9×√10)/6x = 3√10/6x = √10/2x
7 - 2x - 5y=-7
3x + 4y = 7
Answers
-5y = 2x
-5y/5 = y
2x/5 = 2x/5
y = 2x/5
4y = -3x + 7
4y/4 = y
-3x/4 + 7/4
y = -3x/4 + 7/4
160% of 30
I’ve been stuck on this question for hours I REALLY need help
Answers
Answer:
The answer is 48
Step-by-step explanation:
160% is the same as 1.60
A percent of something means you have to multiply them together
1.60 times 30=48
Hope this helps!!
The train station clock runs too fast and gains 5 minutes every 3 days.
How many minutes and seconds will it have gained at the end of 7 days?
Answers
9514 1404 393
Answer:
mm:ss = 11:40
Step-by-step explanation:
We assume the amount of gain is proportional to the time that passes.
g/7 = 5/3
g = 7(5/3) = 35/3 = 11 2/3 . . . . minutes
The clock will have gained 11 minutes and 40 seconds after 7 days.
You are the operations manager for an airline and you are considering a higher fare level for passengers in aisle seats. How many randomly selected air passengers must you survey? Assume that a prior survey suggests that about 22% of air passengers prefer an aisle seat. Assume that you want to be 98% confident that the sample percentage is within 5.1 percentage points of the true population percentage.
Answers
Answer:
358 randomly selected air passengers must be surveyed.
Step-by-step explanation:
In a sample with a number n of people surveyed with a probability of a success of [tex]\pi[/tex], and a confidence level of [tex]1-\alpha[/tex], we have the following confidence interval of proportions.
[tex]\pi \pm z\sqrt{\frac{\pi(1-\pi)}{n}}[/tex]
In which
z is the zscore that has a pvalue of [tex]1 - \frac{\alpha}{2}[/tex].
The margin of error is given by:
[tex]M = z\sqrt{\frac{\pi(1-\pi)}{n}}[/tex]
98% confidence level
So [tex]\alpha = 0.02[/tex], z is the value of Z that has a pvalue of [tex]1 - \frac{0.02}{2} = 0.99[/tex], so [tex]Z = 2.327[/tex].
Assume that a prior survey suggests that about 22% of air passengers prefer an aisle seat.
This means that [tex]\pi = 0.22[/tex]
How many randomly selected air passengers must you survey?
We need a sample of n, and n is found for which [tex]M = 0.051[/tex]. So
[tex]M = z\sqrt{\frac{\pi(1-\pi)}{n}}[/tex]
[tex]0.051 = 2.327\sqrt{\frac{0.22*0.78}{n}}[/tex]
[tex]0.051\sqrt{n} = 2.327\sqrt{0.22*0.78}[/tex]
[tex]\sqrt{n} = \frac{2.327\sqrt{0.22*0.78}}{0.051}[/tex]
[tex](\sqrt{n})^2 = (\frac{2.327\sqrt{0.22*0.78}}{0.051})^2[/tex]
[tex]n = 357.2[/tex]
Rounding up
358 randomly selected air passengers must be surveyed.
Help!!
A class rolled number cubes. Their results are shown in the table.
What is the experimental probability of rolling a number less than 5?
67.8%
49.5%
34.4%
84.7%
Answers
Answer:
A. 67.8%
Step-by-step explanation:
the total number of occurences are 202
Now the total number of occurencess for 4 and below are 137
So Heres the quickest way to do it: Divide 137 by 202 then multiply it by 100 being 100%
Then you would get 67.8, then well put the percent sign behind it.
There are five boys to every nine girls in an introductory engineering course .if there are 364 students enrolled in the course , how many are boys ?
Answers
Answer:
234
Step-by-step explanation:
So what we know is that
5x+9x= students
This equation is saying that for every 5 boys there are 9 girls
we can then plug in 364 for the number of students and add like terms
This means that 14x=364
this means that x=26
This means that there are 26 sets of 5 boys and 9 girls
this means that there are
130 boys
234 girls
The Martin family's truck gets an average of 24 miles per gallon. Predict how many miles they can drive using 5 gallons of gas.
Answers
Answer:
120 miles
Step-by-step explanation:
just take 24*5 to get how many miles they can travel which would be 120 miles
PLZ HELP ME WITH MY HW?????
Answers
Answer:
Uh 7/24?
Step-by-step explanation:
Just doing this in my head fyi lol
Put the following fractions in their simplest forms.
6/9
11/88
Answers
1/8
Would be the simplest forms
6/9 to 2/3
11/88 to 1/8
Help plz will give brainliest!
Answers
Answer:
ExponentialStep-by-step explanation:
Please answer this correctly without making mistakes
Answers
Answer:
1 mi 1927 ft
Step-by-step explanation:
Turn everything into feet:
5mi x 5280 ft/1 mi = 26,400ft + 1,348 ft = 27, 748 ft
3mi x 5280 ft/1 mi = 15,840ft + 4,701 ft = 20,541 ft
Do the subtration that the problem wants you to do:
27, 748 ft - 20,541 ft = 7,207 ft
Turn the answer into mi & ft:
7,207 ft - 5280 ft = 1927 ft
=
1 mi 1927 ft
The data distribution is ___
Answers
Skewed right
Explanation:
The data is higher on the right
Answer:
skewed left
Step-by-step explanation:
Phil bought two hamburgers and a milk shake
for $10.30. Janice bought three hamburgers and
a milk shake for $14.80. What is the cost of the
two milk shakes?
A. $1.30
B. $1.45
C. $2.60
D. $4.50
Answers
Answer:
C.
Step-by-step explanation:
[tex]\left \{ {{2x+y=10,3} \atop {3x+y=14,8}} \right.[/tex]
[tex]\left \{ {{y=10,3-2x} \atop {y=14,8-3x}} \right.[/tex]
10,3-2x=14,8-3x
x=4,5 - one hamburger
y=1,3 - one milk shake
OR:
$14,8-$10,3=$4,5 - one hamburger
2*4,5+y=10,3
y=1,3 - one milk shake
2y=2,6
For the equation y = - 3x + 2 2. determine the value of y when x = 2?
Answers
Y = -6 +22
Y = 16
Answer:
y=16
Step-by-step explanation:
x=2
y=-3x+22
y=-3(2)+22 then y=-6+22, y=16
"Hunter read 40 pages in his history book in
one hour.
Rate of change is
Answers
PLZ HELP BRAINLIEST
Create a scenario that requires use of the Fundamental Counting Principle to find the probability. Calculate the probability.
Answers
Answer:
see explanation below
Step-by-step explanation:
You have three pairs of shoes (white, brown, and black), and you have 6 pairs of pants ( brown, blue, grey, white, sand, and black)
We use the Fundamental Counting Principle to find the number of possible pant-shoe combinations:
3 * 6 = 18
then we can find the probability of wearing by random selection brown shoes with either blue or grey pants:
prob (brown shoes & blue pants) + prob (brown shoes & grey pants) =
= 1/18 + 1/18 = 2/18 = 1/9
x^3 + 5x^2 + 2x + 10 = 0
Answers
Let's solve your equation step-by-step.
x3+5x2+2x+10=0
Step 1: Factor left side of equation.
(x+5)(x2+2)=0
Step 2: Set factors equal to 0.
x+5=0 or x2+2=0
x=−5
Answer:
x=−5
What number can be a common denominator for 3/4 and 1/8
Answers
Answer:
8
Step-by-step explanation:
3/4 = 6/8
Answer:
of course8 cause common can be like
4×2Need this quick please!
Select the correct answer.
1+ 3
Which expression is equivalent to 12 - 21
-
12 + 21 - 3
I +1 if no denominator equals zero?
3
O A
o
B.
1
12 – 21 – 3
1
12 – 40 + 3
1
12 + 2.1 – 3
I + 3
1+1
OC.
OD
Answers
Answer:
C is the answer i think
Step-by-step explanation:
Howard buys a new comforter set for 15% off the original price of 54$.What is the sale price?
Answers
Answer:
$45.90
Step-by-step explanation:
What 15% off means is 85% of the original price ($54). 85% is the same as 17/20. Multiply 17/20 by 54 (or multiply 3/20 by 54 and subtract that from 54) to get the sale price.
(17 * 54)/20 (Multiply 17 by 54)
918/20 (Reduce if needed)
459/10 (Divide 459 by 10)
45.9
The sale price of the comforter is $45.90.
30 points! Need help ASAP!
Answers
Help me please omg. Am having trouble with this.
Answers
Answer:
Part A 225-81=144
Step-by-step explanation:
1. 15×15 =225
2. 3×3×3×3 =81
A 16-foot ladder must reach 13 feet up a building. What's the measure of the angle
that the ladder makes with the ground?
OA) 39.090
OB) 3.6°
C) 54.34°
D) 35.66°
Answers
Do you wanna build a snowman or ride our bikes around the halls.
The correct answer is C) 54.34°.
Fifteen hungry kittens found a bucket of sausages. Each time they cut a sausage or a part of a sausage, they cut it into exactly two new pieces. They made 20 cuts in all and each kitten got 2 (maybe unequal) pieces of sausage. How many sausages were in the bucket?
Answers
Answer:
There is a total of 10 sausages. I am 100% sure.
Step-by-step explanation:
A bucket of sausages fed 15 hungry kittens. Each sausage or half of a sausage is sliced into two pieces. They chopped 20 sausages and gave each kitten two (perhaps unequal) portions. Therefore, there were 34,952 sausages in the bucket.
At the start, there is one sausage bucket, and the 15 kittens want to share it.
The first cut divides the sausage into two pieces.
After the second cut, there are four pieces of sausage.
After the third cut, there are eight pieces.
After the fourth cut, there are 16 pieces.
As we can observe, the number of pieces of sausage doubles with each cut. After 20 cuts, there will be 2²⁰ (2 raised to the power of 20) pieces of sausage.
Now, since each kitten received two pieces of sausage, the total number of sausages in the bucket can be calculated by dividing the total number of pieces by 2 × 15 (since there are 15 kittens).
Total sausages = (2²⁰) / (2 × 15)
Let's simplify this:
Total sausages = 2¹⁹ / 15
Now, let's calculate the value:
Total sausages = 524,288 / 15
Total sausages = 34,952.53
Since you can't have a fraction of a sausage, we need to round down to the nearest whole number.
Therefore, there were 34,952 sausages in the bucket.
To know more about number
https://brainly.com/question/251701
#SPJ2
10 POINTS
8TH GRADE MIDDLE SCHOOL MATH
Answers
Answer:
first one is the answer to this
Step-by-step explanation:
Click the picture
Giving brainlist
Answers
Answer:
5
The value of y is also 5!
The value of pair (x,y) is (5,5)
Hopefully this helped! :D
-LavenderVye
