ISA 235 Sircar
Jenna Senn
ISA 235A
Homework 2
Exercise #11
From the tables: How many different (unique) properties were viewed in May, 1995? (You should
answer by visually examining the tables and creating a table using Microsoft Word.)
Write the SQL code
2-4
Inventory is allocated so it can be given to the correct people and to make sure it is not sold to
someone else. Also, we need to make sure that we have the inventory in stock.
2-5
Credit must be allocated to customers so they dont overextend credit,
ISA 235
steigej2
CUSTOMER
Submit Order
Respond to
Quotation
Process Order
Responce
SALES PERSON
OPERATIONS MANAGER
Prepare Quote
with Standard
Terms
CREDIT MANAGER
SALES VP
Inventory DB
Check for
available
inventory
Submit Quote
Customer Accept the
Quotat
Beatriz Su (subm)
Lab 9
04/12/2017
1. Run all possible regressions using adjusted r-squared as the criteria and looking at the 10 best models.
proc reg data=work.sales;
model Sales= Time MktPoten Adver MktShare Change Accts WkLoad Rating /
selection=adjrs
Beatriz Su (subm)
Lab 6
03/08/17
1) A) FemaleLifeExp (hat) = 63.60591 2.04828(PPTVc) 0.15656(PPPDRc) + 0.00042647(PPPDRsq)
B) All the variables in the model are significant for an alpha of
0.1, because when conducting a hypothesis test for each beta
being
Beatriz Su (subm)
Lab 3
Part 1
proc reg data = TMP1.Computer_Lab_3_Data
plots (maxpoints=none);
model Small_Cap=Large_Cap;
run;
02/08/2017
Beatriz Su (subm)
Lab 3
02/08/2017
1)
E() = 0.
The variance of the probability distribution of is constant for all
Beatriz Su (subm)
Lab 5
03/01/17
Instructions / Questions For Computer Lab 5
1. The data for you to analyze is in an excel workbook named first quarter.xls. This workbook is included with the
assignment description in Canvas. It contains the daily closing
Beatriz Su (subm)
Lab 7
03/15/2017
1) proc reg data=work.navy;
model percent = costce;
run;
a. Percent = 0 + 1(costce) +
b. Percent (hat) = 17.2 + 0.31096 (costce)
c. R-square = 84.22% and adjusted R-square = 82.25%
d. With an alpha of .1, the model is s
Beatriz Su (subm)
ISA 291
LAB 1
1)
2)
3) Based on the mean and median values only:
Y1 and Y4 are symmetric, because both mean and median values are approximately the same.
Y2 has a mean slightly larger than the median, so it is probably skewed to the righ
Beatriz Su (subm)
Lab 8
06/04/2017
Computer Lab 8
1. In this lab you will be using the same salary data we used in class located in the workbook
EXECSAL.xlsx. This data is described in the chapter 5 powerpoint. In this workbook, the second
worksheet has t
Beatriz Su (subm)
Lab 4
1)
data one;
set tmp1.computer_lab_4_data;
run;
proc corr data = work.one
plots (maxpoints=none) = matrix(histogram);
var TIME DEPTH;
run;
proc reg data = work.one
plots (maxpoints=none);
model TIME=DEPTH;
run;
02/17/2017
Beatriz S
Beatriz Su (subm)
Lab 10
04/15/2017
1. Use either excel or SAS to create the appropriate square and interaction terms.
2. Run a stepwise regression in SAS using Slenter = Slstay = 0.1. Don't forget to use an include statement.
Because of the include state
Computer Lab using JMP The symbol * means an answer is needed.
Lab 1 Starting to Use JMP
Data Set: Denim.jmp
Summary
In this lab you will open existing data and will graph and summarize data in JMP using
Analyze > Distribution. Youll create a report with
Exam 1 Practice Questions 1
_1.
In a multiple regression analysis an observation is found to be an outlier with respect to x. This means
that
A) It will be an outlier with respect to y
B) It will be an influential observation
C) It will have a relatively
Exam 3 Practice Questions 3 Answers
_B_1.
The variance inflation factor measures the strength of the linear relationship between the
dependent variable and the independent variables in the regression model.
A) True
_A_2.
In a multiple regression model if
Simple Linear Regression Analysis Some Practice Questions
1.
Fill in the blanks on the SAS regression analysis output below.
Variable
DF
Intercept
Cars (MM)
1
1
Parameter
Estimate
20.78
12.7122
Standard
Error
18.26
0.8292
t value
Pr > |t|
_
_
0.284
0.000
Exam 3 Practice Questions 3
_1.
The variance inflation factor measures the strength of the linear relationship between the
dependent variable and the independent variables in the regression model.
A) True
_2.
In a multiple regression model if the largest
Exam 3 Practice Questions 2
For questions 1 3 consider the four models described below fit using the same data. All four models are statistically
significant and all of their terms are also statistically significant.
Model Number
1
2
3
4
Number of Indepen
Exam 1 Practice Questions 1 Answers
_C_1.
In a multiple regression analysis an observation is found to be an outlier with respect to x. This means
that
A) It will be an outlier with respect to y
B) It will be an influential observation
C) It will have a r
Exam 3 Practice Questions 2 Answers
For questions 1 3 consider the four models described below fit using the same data. All four models are statistically
significant and all of their terms are also statistically significant.
Model Number
1
2
3
4
1.
Number
ART 188: RLR 2
Michelangelo, David (1501-04)
Michelangelo, Awakening Slave (1520-23)
Michelangelo was not just an artist, but also an accomplished poet whose themes often reflect on
what it means for him to be a creator. The poems Im having you read both
ART 188 RLR 1
Filippo Brunelleschi
Lorenzo Ghiberti
One of the most important events in the history of art was the competition to award the
lucrative task of designing and executing the imagery for the bronze doors of the Baptistery in
Florence, one of th
[-PDF-].Unlimited Learn Python 3 the Hard Way: A Very
Simple Introduction to the Terrifyingly Beautiful World of
Computers and Code (Zed Shaw s Hard Way Series)
Review.EBook Full Free
Are you ready! To Download Learn Python 3 the Hard Way: A Very Simple I
Xiaotong Xiu
ISA235 Section I
3/30/2017
2.
SELECT Products.ProductName, Employees.FirstName, Employees.LastName,
TO_CHAR(SUM(OrderDetails.Quantity) AS TotalQuantity
FROM
northwinds.Products
JOIN
northwinds.OrderDetails
ON
Products.ProductID=OrderDetails.P
ISA 245 Database Systems and Data Warehousing
2016 Spring - Course Syllabus & Schedule
Class Information
Prerequisite:
Time:
Instructor
Name:
Office:
Office Hours:
ISA 235 (or equivalent approved by instructor)
Section A: MW 8:30 9:50, FSB 2050
Jay Palmis
ISA245
REVIEW EXERCISE: USING THE SELECT STATEMENT
For this set of exercises use the Adventure Works (Light) database. It is named MISAWLT on
our Oracle server. For each item below, write SQL statements to access the desired data. Create
an MS Word docume
ISA 245 Spring, 2016 Jay Palmisano
Midterm Exam Study Guide
Notes:
This guide is structured by chapters in your textbook. For each chapter, there is a list of concepts
that you should understand and key terms that you should also understandin most cases t
ISA 245 Spring, 2016 Jay Palmisano
Final Exam Study Guide
Notes:
This guide is structured by chapters in your textbook. For each chapter, there is a list of concepts
that you should understand and key terms that you should also understandin most cases thi