BUSA 501: ASSIGNMENT 1
1
ASSIGNMENT 1: LINEAR MODEL
A. Estimated regression equation to predict percentage of games won, given the average
number of passing yards per attempt:
= -58.770+ 16.390X
BUSA 501: ASSIGNMENT 1
2
R square = 0.5771331609, which mea
BUSA 501: ASSIGNMENT 2
ASSIGNMENT 2: LINEAR MODEL WITH DUMMY VARIABLES
A. The Multiple Regression equation to relate risk of stroke to persons age, blood pressure
and smoking habit of the person is
1
BUSA 501: ASSIGNMENT 2
2
= - 91.7594+ 1.076 X1 + 0.251
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.661739
R Square 0.437898
Adjusted R 0.397748
Standard E 18.3008
Observatio
16
ANOVA
df
Regression
Residual
Total
1
14
15
SS
MS
F Significance F
3652.8
3652.8 10.90651 0.005236
4688.87 334.9193
8341.67
Coef
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.759693
R Square 0.577133
Adjusted R 0.546928
Standard E 15.87319
Observatio
16
ANOVA
df
Regression
Residual
Total
SS
MS
F Significance F
1 4814.254 4814.254 19.10735 0.000639
14 3527.416 251.9583
15 8341.6
ASSIGNMENT-4
MARKET BASKET ANALYSIS
BUSA 501: INTRODUCTION TO BUSINESS ANALYTICS
Please find the attached Excel Sheet in the task.
A.
B. 10 rules have a support count of at least 250 and confidence of 50%:-
1
C. Using the list of rules from part b, consid
ASSIGNMENT 2
LINEAR MODEL WITH DUMMY VARIABLES
A. The Multiple Regression equation to relate risk of stroke to persons age, blood pressure
and smoking habit of the person is
= - 91.7594+ 0.251 X1 + 1.076 X2 + 8.739 X3
Dependent Variable (): Risk of strok
ASSIGNMENT 3
LINEAR MODEL TO ANALYZE TIME SERIES DATA
A. Time Series plot
Cost
40
35
30
25
Cost
20
15
10
5
0
1
2
3
4
5
Year
6
7
8
B) Simple Linear regression analysis
Equation
.
= 1.774*X+19.992
C) The average cost increase that the firm has been realizi
4. Which of the following inferences can be drawn from the scatter chart given below?
8. Which of the following data patterns best describes the scenario shown in the below plot?
9. Which of the following data patterns best describes the scenario shown in
- This assignments maximum page limit is 3 pages.
- Times New Roman 12 font size, double spacing
_
As a team, pick an American leader that you find charismatic.
As a team, pick a leader in another country that you find charismatic (For example,
Ataturk).
BUSA 501 Introduction to Business Analytics
Assignment I
ASSIGNMENT - I
Chapter - 4
Q12 SOLUTION
a
Estimated regression equation used to predict percentage of games won given the average
number of passing yards per attempt:^
Y = -58.770+ 16.390X1
Proporti
Assignment 1
(a) Develop the estimated regression equation that could be used to predict the percentage
of games won, given the average number of passing yards per attempt. What proportion
of variation in the sample values of proportion of games won does
Assignment 3
a. Construct a time series plot. What type of pattern exists in the data?
The trend reflects increase over years as Year 3 cost/unit $28.2, year $6 cost/ unit
It implies that increase in cost have positive linear association with growth in pr
Assignment 4
a. Using a minimum support of 100 transactions and a minimum confidence of 50 percent,
use XLMiner to generate a list of association rules. How many rules satisfy this
criterion?
With 100 transactions and a minimum confidence of 50%,581 assoc
Assignment 2
a.
Develop an estimated multiple regression equation that relates risk of a stroke to the
persons age, systolic blood pressure, and whether the person is a smoker.
Estimated Multiple regression equation that relates risk of a stroke to the pe
Chapter Two
2-1
The Marketing Research Industry Members
Consumer and industrial
Field services firms
goods and services producers
Specialized services firms
Media Companies
Syndicated services
Online and mobile
tracking firms
Custom research firms
How to Create y and ^y in the Data Analysis Report?
1. Click Insert tab on the top of the Word document
2. Click the upside down triangle on the Equation button, and then select Insert
New Equation
3. Click the Design tab on the top, and then click upside
How to Create
b0
and
b1
in the Data Analysis Report?
1. Click Insert tab on the top of the Word document
2. Click the upside down triangle on the Equation button, and then select Insert
New Equation
3. Click the Design tab on the top of the Word document,
Solutions to Q9 on pp. 313 Big Data in Market Basket Analysis
a. The store recorded 1001 customers purchases. Each row represents each customers orders.
(1) Click XLMiner Platform, then Associate, and then Association Rules
(2)Because the first row contai
How to Perform the Sensitivity Analysis using Solver
After reaching the best objectives (e.g., maximum profits) by using the linear optimization analysis,
some analysts maybe want to know more about the manufacturing process, such as which department
has
How Many Dummy Variables Are Needed?
Some categorical factors only have two categories. For instance, the Gender factor in the fitness
app example only has male and female. Some categorical factors have more than two categories.
For instance, customers ca
Supervised Learning Analysis Classification Tree
I introduced the supervised learning strategy to everyone in the video lecture. When using this
strategy, we still draw one sample to build analytical model, but we split this sample into three
smaller data