Refer to Figure 1. Which of the following Excel expressions would you use to randomly access sales values from the general distribution table? =NORMINV(RAND(), µ, s)

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter7: Distance And Approximation
Section7.3: Least Squares Approximation
Problem 31EQ
icon
Related questions
icon
Concept explainers
Topic Video
Question

R3

B.
D
Sales
Probability
10
0.10
3.
20
0.15
30
0.15
40
0.25
50
0.25
60
0.10
8.
6.
2.
7.
Transcribed Image Text:B. D Sales Probability 10 0.10 3. 20 0.15 30 0.15 40 0.25 50 0.25 60 0.10 8. 6. 2. 7.
Refer to Figure 1. Which of the following Excel
expressions would you use to randomly access sales
values from the general distribution table?
Q =NORMINV(RAND(), µ, s)
=RANDBETWEEN(a,b)
O =AVERAGE(Range1)
O =GENERAL(Range1, Range2)
=VLOOKUP(RAND(0,Range, Column)
=SUMPRODUCT(Range1, Range2)
O =MAX(Range1, Range2)
Transcribed Image Text:Refer to Figure 1. Which of the following Excel expressions would you use to randomly access sales values from the general distribution table? Q =NORMINV(RAND(), µ, s) =RANDBETWEEN(a,b) O =AVERAGE(Range1) O =GENERAL(Range1, Range2) =VLOOKUP(RAND(0,Range, Column) =SUMPRODUCT(Range1, Range2) O =MAX(Range1, Range2)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Angles, Arcs, and Chords and Tangents
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning