COURSE PAPER
Course paper
BUSN660: Advanced Analytics I
Ha Nguyen
American Public University System
Table of Contents
Abstract.2
The use of Analytics and Data.3
Linear Regression.5
Linear Programing.9
Car
Compact
Standard
Luxury
Chad's commission (on sale)
$900
$1,500
$3,000
Chad's selling costs
$600
$200
$600
Chad should take the offer and sell the compact car, then sell the luxury car next in ord
This week, we introduced several statistics concepts or tools used to visualize and interpret data.
Please select one or two of them and explain how you may use it in a real world example
Population a
Dynamic pricing is the practice of pricing items at a level determined by a particular customer's
perceived ability to pay (Google Dictionary, 2017) but an article in Forbes argues that it is not
pers
Using the template provided, work the assigned problems:
Chapter 6
Exercise 1
Exercise 2
Once you have familiarized yourself with this week's materials, please write an APA
format paper to report your
Sample of Chip Weights (grams)
Count
Min
43.39
Max
57.57
Range
14.18
44.32
48.42
47.86
54.24
47.67
49.26
49.81
3.70
possibly 5%
See Histogram
0
Use 2*standard deviation of mean
55.06
47.87
45.8
49.22
Running head: SIMULATIONS WITH RANDOM EXCEL FUNCTIONS 1
Random Functions in Excel:
Simulation Exercises
Holly K Qualman
American Public University
SIMULATIONS WITH RANDOM EXCEL FUNCTIONS 2
Abstract
Th
1. Develop two simulation models of tossing two six-sided dice (numbered 1 through 6 on
the six faces).
Model 1: Simulate rolling a single die twice and add the total.
Model 2: Simulate a combined rol
WEEK 3: Data-Driven Decision Making
Data can provide a factual base for decisions: some firms say that they are fact-based
decision makers. Data, however, starts out as just numbers and it must be pro
WEEK 2
This week, we will learn how to make Analyzing Sequential Decisions. After this lesson, you need to
grasp the following groups of concepts.
1. Axioms of Probabilities.
2. Expected Value.
3. Con
I quite like the decision making process set out by Dartmouth University. This process takes 7 steps. The
first step is to identify the decision in this you understand that a decision is needed and yo
Week_3 Homework Assignment
Table of Contents
Part 1 of 2 - Part 1
A potato chip manufacturer was having problems with the Weights and Measures inspectors after
the inspectors found some bags containin
Objective approach
Number of occurances of the event
Total number of trials or outcomes
realtive frequency approach p(event)
13
52
0.25
Union of 2 events
probability of a
probability of b
probablilty
What is the importance of a decision tree in the modeling process? What add-ins are available for
Microsoft Excel to assist with the decision tree process? Can you find one that is free? What is the
b
Part 1 of 2 - Part 1
Chad operated an automobile sales business. A major dealer in town offered Chad a one-time
opportunity to help them sell some trade-ins. Under this deal (see table in the attached
cost up front
testing
cost of possible failure
cost of undetected but tested failure
Cost of diagnosis of found problem
Total
savings before purchase
Option 1 Option 2 Option 3 outcome used 1
800
500
Question 1 of 9
10.0 Points
Run a (linear) regression of S&P Index against Date, the P-value is 7.71 E -9 . (Hint: Please use
the "E" notation and keep two decimal points for the first number and ente
An advertisement in the newspaper offers a new car for sale or lease. The purchase price of the car is $43,240, or the car c
Develop a simulation model to compare the net present value of buying or le