Bottom % Cutof
X bar
SD
Bottom _%
Cutof
#VALUE!
Top % Cutof
X bar
SD
#VALUE!
1
Err:502
% of _ more than _
X
X bar
SD
Cumulative
Percent
77
7
Probability
Err:502
1
Last less than _ ?
% of _ no more than _
X
X bar
SD
Cumulative
Percent
X
X bar
SD
Cumulative
Test 2 MGSC 207
Midterm # 2
1 Predict square footage of someones home
(Keep an eye out for the units) Ex. Income 40 Measured in thousands. Annual Income $40,000
2 Is one of the variables not linearly related? Take out?
3 Linear Regression model. What was
standard error of estimate
confidence = average [price of all cars w 10k miles
prediction = price range for 1 car w 10k miles
test
slope @ pop level =0
slope @ pop level not equal 0
heat cost mean temp
30
dnr h0 no linear relationship
r h0 =lin rel
attic
Two Tailed Hypotehsis Test
Chapter 4. Notes Page 15
Inputs
Alpha
0.05
Outputs
Standerdized Test Statistic
SD
0.5
Lower Critical
3.821081
1.095445
Miou Ho
4
Upper Critical
4.178919
Sample n
30
*2*
Z a/2
1.959964
Standard error of the mean
0.091287
X bar
4.
A p-value (observed significance level) is the probability of obtaining a test statistic value equal to or more extreme than that obtained
from the sample data when the null hypothesis is true.
An event is a collection of one or more outcomes from a samp
Chapter 10
Introduction to Data
Mining
Data Mining
Data mining is focused on better understanding
of characteristics and patterns among variables in
large databases using a variety of statistical and
analytical tools.
It is used to identify relationships
Homework # 2 (Chapter 4)
Problem 1
Compute the coefficient of variation for each stock over the 20 day period in the 'Stock Price' Data tab.
From your results, identify which stock is the best financial investment.
Problem 2
The 'Metal Ring Data' tab cont
Many commercial software packages can be used
for Business Analytics.
Spreadsheet software, such as Microsoft Excel, is
widely available and used across all areas of
business.
Spreadsheets provide a flexible modeling
environment for manipulating data and
(Business) Analytics is the use of:
data,
information technology,
statistical analysis,
quantitative methods, and
mathematical or computer-based models
to help managers gain improved insight about
their business operations and make better, factbased
Data visualization - the process of displaying
data (often in large quantities) in a meaningful
fashion to provide insights that will support better
decisions.
Data visualization improves decision-making, provides
managers with better analysis capabilit
Population - all items of interest for a particular
decision or investigation
- all married drivers over 25 years old
- all subscribers to Netflix
Sample - a subset of the population
- a list of individuals who rented a comedy from
Netflix in the past ye
Normal Distribution
probability of
population mean
standard deviation
sample size
x
mean (mu)
SD
n
LESS THAN
0.3694413
56
60
12
9
lower x
higher x
mean
SD
n
56
63
60
12
9
BETWEEN
0.229265
For problems with a sample size look below
for problems with a samp
Inputs
x
Intercept,b0
Slope, b1
alpha
sample size, n
standard error
Sum x
Sum X^2
25
18.9476
1.1842
0.05
10
9.901
220
5600
CI
Yhat
t value
SQRT
PI
48.5526
2.306004
0.334428
CI
41 56
1.054439
PI
24 73
Test Statistic
X bar
miou Ho
sd
n
Z Critical
56.42
60
1
Microsoft Excel 15.19 Answer Report
Worksheet: [MGSC 207 Final Project.xlsx]Sheet1
Report Created: 5/18/2016 3:22:02 PM
Result: Solver found a solution. All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Tim
Microsoft Excel 15.19 Answer Report
Worksheet: [Workbook1]Sheet1
Report Created: 4/27/2016 8:28:12 PM
Result: Solver found a solution. All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 1.491778 Second
Russell Cecil
MGSC 207
Professor Rajeev Sachdev
20 September 2016
Exercise 2
#3
Summary: Basically I highlighted all the data in the Hours online/week column and in the
Friends column and went to insert graph. From there I chose a scatter diagram.
#6
Summ