PS2
Return to Assessment List
Part 1 of 1 Question 1 of 4
100.0 Points
25.0 Points
Solve Problem and Applications:ch3-prob1 p90:
3-1: Consider the experiment of drawing two cards from a deck in which all picture cards have
been removed and adding their va
Question 1: Solve Problem and Applications: ch11- prob 8, in your textbook.
11-8: Suppose that a car rental agency offers insurance for a week that will cost $10 per day. A
minor fender bender will cost $1,500, while a major accident might cost $15,000 in
Question 1 of 5
The three types of inputs common to decision models are: Data, uncontrollable variables, and
decision variables.
True
False
Answer Key: True
Question 2 of 5
Describe how to use Excel data tables, Scenario Manager, and goal seek tools to an
Part 1 of 1 -
100.0 Points
Question 1 of 4
25.0 Points
Solve Problem and Applications:Solve Problem and Applications: ch 6- prob12 (Home market
values).
Using the data in the Excel file Home Market Value, develop a multiple linear regression model
for est
Spreadsheet Modeling
& Decision Analysis
A Practical Introduction to
Management Science
5th edition
Cliff T. Ragsdale
Chapter 3
Modeling and Solving LP
Problems in a Spreadsheet
Introduction
Solving LP problems graphically is only
possible when there are
BUSN625 Week 4 Quiz
Question 1 of 5
The statistical methods used in forecasting are:
20.0 Points
A.Formal forecasting
B.Methods of prediction of the future
C.Multiple Regression Analysis, Nonlinear Regression, Decomposition Method,
Moving Average Analysis
BUSN625 Week 1 Quiz
Question 1 of 5
20.0 Points
Explain the importance of statistics in business.
A.Research & Data
Analysis
B.Problem Solving
C.Decision Making
D.All the above
Answer Key:
D
Question 2 of 5
What is the difference between a population and
BUSN625 Week 5 Quiz
Question 1 of 5
20.0 Points
The three types of inputs common to decision models are: Data, uncontrollable variables,
and decision variables.
True
Fals
e
Answer Key:
True
Question 2 of 5
20.0 Points
Describe how to use Excel data tables
BUSN625 Week 3 Quiz
Question 1 of 5
Explain the difference between the null hypothesis and alternative hypothesis.
20.0 Points
A.There is no difference, both are the same
B.Null hypothesis is what is tested, but alternative hypothesis is what is accepted
BUSN625 Week 6 Quiz
Question 1 of 5
20.0 Points
There are types of decisions that do not involve uncertainty or risk and common approaches
used for analyzing them. Decisions that use financial analysis, optimization models, and
decisions with a single alt
BUSN625 PS3
25.0 Points
Question 1 of 4
Solve Problem and Applications:Solve Problem and Applications:ch 5- prob1 (use excel file
Call Center Data)
5-1: 1. Call centers typically have high turnover. The director of human resources for a large
bank has com
BUSN625 Week 2 Quiz
Question 1 of 5
The three perspectives of probability are:
20.0 Points
A.Fair, good, and excellent
B.Subjective, classical, and
empirical
C.Random, event, and
experiment
Answer Key:
B
Question 2 of 5
What is the z score formula used fo
BUSN625 PS2
Question 1 of 4
25.0 Points
Solve Problem and Applications:ch3-prob1 p90:
3-1: Consider the experiment of drawing two cards from a deck in which all picture cards
have been removed and adding their values (with ace = 1).
a. What is the sample
BUSN625 PS4
25.0 Points
Question 1 of 4
Solve Problem and Applications:Solve Problem and Applications: ch 6- prob12 (Home market
values).
Using the data in the Excel file Home Market Value, develop a multiple linear regression
model for estimating the mar
BUSN625 PS1
Question 1 of 5
20.0 Points
$28.37, $21.40 are the stock prices of a particular month of Microsoft and Intel Corporations.
A.Ratio
B.Ordina
l
C.Nomin
al
D.Interv
al
Answer Key:
A
Question 2 of 5
20.0 Points
In a marketing study, 100 consumers
BUSN625 PS6
Question 1 of 4
25.0 Points
Solve Problem and Applications: ch 12- prob 2, at the end of chapter 12 in your textbook.
12-2: Suppose that the service rate to a waiting line system is 10 customers per hour
(exponentially distributed). Analyze ho
Solve Problem and Applications: ch 12- prob 2, at the end of chapter 12 in your textbook.
12-2: Suppose that the service rate to a waiting line system is 10 customers per hour
(exponentially distributed). Analyze how the average waiting time is expected t
Part 1 of 1 -
100.0 Points
Question 1 of 5
20.0 Points
The statistical methods used in forecasting are:
A. Formal forecasting
B. Methods of prediction of the future
C. Multiple Regression Analysis, Nonlinear Regression, Decomposition Method,
Moving Averag
PS4
Return to Assessment List
Part 1 of 1 Question 1 of 4
100.0 Points
25.0 Points
Solve Problem and Applications:Solve Problem and Applications: ch 6- prob12 (Home market
values).
Using the data in the Excel file Home Market Value, develop a multiple lin
PS1
Return to Assessment List
Part 1 of 1 For the following data, choose the correct level of measurement.
Question 1 of 5
100.0 Points
20.0 Points
$28.37, $21.40 are the stock prices of a particular month of Microsoft and Intel Corporations.
A.Ratio
B.Or
Help file for week 1 problem set
#1:
$855.80 and $749.25 are the weekly salaries of two employees in XYZ company.
This data would be classified as ratio. Ratio type data will have an inherent zero. In this example.
Dollar has an absolute zero. In addition
What is data? What is sampling? Explain the importance of sampling from a managerial perspective. Provide examples.
Data can be defined as values of qualitative or quantitative facts that are critical to produce a product or to feed analysts as a basis fo
Question 1 of 5
There are types of decisions that do not involve uncertainty or risk and common approaches
used for analyzing them. Decisions that use financial analysis, optimization models, and
decisions with a single alternative are good examples.
True
Part 1 of 1 Question 1 of 5
20.0 Points
The three perspectives of probability are:
A. Fair, good, and excellent
B. Subjective, classical, and empirical
C. Random, event, and experiment
Answer Key: B
Question 2 of 5
20.0 Points
What is the z score formula
Part 1 of 1 -
100.0 Points
Question 1 of 4
25.0 Points
Solve Problem and Applications:ch3-prob1 p90:
3-1: Consider the experiment of drawing two cards from a deck in which all picture cards have
been removed and adding their values (with ace = 1).
a. What
Part 1 of 1 -
100.0 Points
Question 1 of 4
25.0 Points
Solve Problem and Applications:Solve Problem and Applications:ch 5- prob1 (use excel file Call
Center Data)
5-1: 1. Call centers typically have high turnover. The director of human resources for a lar
Part 1 of 1 -
100.0 Points
Question 1 of 5
20.0 Points
Explain the importance of statistics in business.
A. Research & Data Analysis
B. Problem Solving
C. Decision Making
D. All the above
Answer Key: D
Question 2 of 5
20.0 Points
What is the difference be
Part 1 of 1 For the following data, choose the correct level of measurement.
100.0 Points
Question 1 of 5
20.0 Points
$28.37, $21.40 are the stock prices of a particular month of Microsoft and Intel Corporations.
A. Ratio
B. Ordinal
C. Nominal
D. Interval
Part 1 of 1 -
100.0 Points
Question 1 of 5
20.0 Points
Explain the difference between the null hypothesis and alternative hypothesis.
A. There is no difference, both are the same
B. Null hypothesis is what is tested, but alternative hypothesis is what is
BUSN625 PS5
Question 1 of 5
20.0 Points
Solve Problem and Applications: ch11- prob 8, in your textbook.
11-8: Suppose that a car rental agency offers insurance for a week that will cost $10 per day.
A minor fender bender will cost $1,500, while a major ac