All categories

3 years ago

What does a formula do in a spreadsheet program? Apex

2 answers:

7 0

MS Office suite is built to help people with their problems. These programs in the suite help them simplify their tasks. With the help of these programs, people save their time significantly.

Specifically talking about the Excel Spreadsheets, there are many built in programs that simplify a consumer's work. there are many built in formulas that are used to get the answers. Only you need is to enter the data and choose the formula you want to apply, then just press enter and the results are generated. Thus the formula function in excel minimize the calculation time and also ensure that there is no error while computing the results.

inessss [21]3 years ago

4 0

A formula helps you understand the problem better!!!

You might be interested in

Alice earned $12 per hour. What equation shows the relationship between her

LenaWriter [7]

The equation shows the relationship between her weekly salary (w), hours per week (h), and rate per hour (r) is:

$w = h \times r$

Solution:

Given that,

Alice earned $12 per hour

1 hour = $ 12

Find the number of hours in 1 week

1 day = 24 hours

1 week = 7 days

Therefore,

1 week = 7 x 24 = 168 hours

Let "h" be the hours per week

let "r" be the rate per hour

Let "w" be the rate per hour

From given,

r = $ 12

h = 168 hours

weekly salary = hours per week x rate per hour

$w = h \times r$

$w = 168 \times 12\\\\w = 2016$

Thus, she earns $ 2016 for 1 week

5 0

3 years ago

Read 2 more answers

Which of the following careers is most likely to require business skills? a)Systems Analyst b)Hardware Engineer c)Software Engin

Olin [163]

Answer:

D. Database Administrator

5 0

3 years ago

M7_IND4. Andre Greipel is the owner of a small company that produces heart rate monitors. The annual demand is for 2,250 heart r

Stolb23 [73]

Answer :

a) Economic Production Quantity = 1,612 monitors

b) Number of setups = 1.4

c) Total cost = $972.12 per year

Explanation :

As per the data given in the question,

a) Economic Production Quantity = sqrt((2 × annual demand × set up cost) ÷ carrying cost × (1 - daily demand ÷ daily production))

=sqrt((2 × 2,250 × $350) ÷ $0.80 × (1 - 35 ÷ 140))

= 1,620.19

= 1,621 monitors

b) Number of setups = Annual demand ÷ Economic production quantity

= 2,250 ÷ 1,621

= 1.3880

= 1.4

c) Formula of Total cost = Carrying cost + Annual setup cost

Carrying cost=(Economic production quantity ÷ 2) × Carrying cost × (1 - daily demand ÷ daily production)

= (1,612 ÷ 2)× $0.80 × (1 -35 ÷ 140)

= $486.30

Annual setup cost = (Annual demand ÷ Economic production quantity) × setup cost

= (2,250 ÷ 1,621) × $350

= $485.812

So, Total cost = $486.30 + $485.812

= $972.12 each year

We simply applied the above formulas

6 0

3 years ago

The marketing researcher for a game company is conducting an experiment to test customer reaction to the pricing of a new game d

SSSSS [86.1K]

Answer:

The correct option is D) The design of the study suffers from selection bias.

Explanation:

In research, Selection Bias occurs when the researcher decides who the respondents are or those who are being evaluated or studied.

Every research ought to be designed in such a way that the respondents are selected at random.

In the information provided, the respondents were selected from a group of people who on a balance of probability were already inclined to decline because it was a list of dissatisfied customers. The chances of them declining to respond or responding with a negative were higher than the chances of them indicating that they would buy and this defeats the purpose of the research. The research ought to have also included a sample of respondents who didn't have the product, who had enjoyed the services of the company and were content, those who didn't even know what the product did until they got the survey.

That way holistic information can be obtained from the research about how different sets of people will react and not just those who are already dissatisfied with the company's product(s).

Some of the ways to avoid selection bias in research are:

To employ the use of random techniques selecting sample sets from populations.
To check that the traits or characteristics of the larger population are well represented in the samples selected

Cheers

4 0

3 years ago

Bob and Lisa are both married, working adults. They both plan for retirement and consider the $2,000 annual contribution a must.

ikadub [295]

Answer

The answer and procedures of the exercise are attached in a microsoft excel document.

Explanation

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.

Download xlsx

6 0

3 years ago