Statistics for management
11/9/14
Homework # 6
Chapter 8
8.42
Pie = .55
0.0287 (Obtained by the square root of 0.55 (1-.55) divided by 300)
0.60 0.55 / .0287 = Z = 1.74
1 0.9591 = .0409
About a 41% chance that at least 60% favor the candidate.
8.44
A) 0(0
Statistics for management
Prof. Chatterji
Homework # 1
9/15/14
1.18
a) It would be a ration scale because it can tell us about the order of the employees and can be
organized into range, median, mean, and mode.
b) The answer is interval scale because the
Statistics
HW# 3
Prof.Chatterji
10/28/14
Chapter 6:
6.1: Random variables is described are considered random because unique numerical value with
every outcome of an experiment.
6.8:
Xi
P(Xi)
XiP(Xi)
$200,000
0.60
120,000
$120,000
0.40
48,000
Potential
Sal
Statistics for management
Prof. Chatterji
12/2/14
HW # 10
15.27
Regression line = 1.66,227, 473 + 64076803x
166,227,473 = constant
X = Number of dealers
For a dealership group consisting of 100 dealers, the point estimate for total revenue is
-166,227,473
Statistics for Management
Prof.Chatterji
HW #2
10/10/14
Chapter 5
5.4: P(A) = Number of outcomes/Total number of outcome
There is a 1/10 chanced that the right hand digit will be a 7.
5.6: This does not mean that the dice is loaded because according to th
Prof.Chatterji
11/4/13
Homework #4
Chapter 7
7.1
Continuous probability distribution is an infinite probability distribution used to find probability for a
continuous range of values. Discrete probability distribution is used to calculate probability for
Prof.Chatterji
Statistics for Management
HW # 8
11/23/14
Chapter 10:
10.8
The claim I nondirectional because it says, about 10% this results in us using a two-tail test in
which the hypothesis can be rejected from an extreme result in either direction.
10
Statistics for management
Prof. Chatterji
Homework # 1 (Chapter 2)
9/15/14
2.17
There are 10 data values in the $30,000 under $40,000 category. There are two portfolio values
at the extremes that seem especially low or high compared to the others which ca
CQS 311
Online Lecture 2
Topics:
Relational Database Management
Systems
Database Design Guidelines
Many-to-many Relationship example
Types of Relationships
Relational Database Management
Systems
(RDBMS) - review
Microsoft Access is a Relational DB
CQS 311
Online Lecture 5
Topics:
Queries and corresponding SQL
Wildcard (*) in select field list - To select all
fields
IS NULL criteria
Numeric Criteria
Compound Criteria (AND, OR)
Query based on more than one Table
Wildcards
Calculated Fields
Calcula
Instructions:
1) Open the Scholarships database and review the tables and relationship between them to get
familiar with your data.
2) Create a new query in Query design pick the table Students
3) Now, go to SQL View and try typing in the following querie
CQS 311
Programming with
VBA
Topics:
Programming Concepts
Excel hierarchy of objects
VBA programming window
Example function MsgBox
Program
A computer program is a sequence of
instructions written to perform a specific
task or tasks on a computer(s)
CQS 311 Fall 2015 Exam 3 topics
Exam 3 will be Excel topics and will be open book and notes.
You will download a spreadsheet with several worksheets in it to start the exam.
Project 8A
Objective 1 Moving Average (Approx. 20 points)
Activity 01 Creating a
CQS 311 Fall 2015 Exam 2 topics
Exam 2 will be Excel topics and will be open book and notes.
You will download a spreadsheet with several worksheets in it to start the exam.
Project 4A
Objective 1 Use Financial Functions
Activity 01 Inserting PMT Function
Binghamton University School of Management
CQS 311 - Advanced Computer Tools OPM/MIS
Fall 2015
Instructor:
Email:
Office Hours:
Janette M. Hicks
Phone:
jhicks@binghamton.edu
Office:
Tuesday 4:15-4:45 pm and online sessions to be announced.
777-6551
AA303
CQS 311 Quiz 1 topics
Relational Database Management System (RDBMS), examples (MS Access, Oracle, MS SQL Server, )
Primary Key (PK) - requirements, determining good PK based on current AND future data
Same name as PK is not required but it must be the sam
CQS 311 Fall 2015
Exam 1 Topic list
Project 1A
Create a table & define fields (name, description, data type, length)
Modify the structure of a table (delete fields, modify fields, set primary key)
Import from Excel
o Create new table or append to exist
CHAPTER 10
HYPOTHESIS TESTS INVOLVING
A SAMPLE MEAN OR PROPORTION
SECTION EXERCISES
10.1 d/p/m The null hypothesis is a statement about the value of a population parameter. It is assumed
to be true unless we have evidence to the contrary. The alternative
CHAPTER 9
ESTIMATION FROM SAMPLE DATA
SECTION EXERCISES
9.1 d/p/e A point estimate is a single number that estimates the value of the population parameter,
while an interval estimate includes a range of possible values which are likely to include the popu
CHAPTER 8
SAMPLING DISTRIBUTIONS
SECTION EXERCISES
8.1 d/p/m The sampling distribution of a statistic is a probability distribution of the sample statistic for all
possible samples of that particular size. Therefore, a sampling distribution is a probabili
CHAPTER 3
STATISTICAL DESCRIPTION OF DATA
SECTION EXERCISES
3.1 c/a/m x = 613.48/30 = $20.449. Median = $20.495, the average of the two values in the middle
when the data are arranged in order of size.
3.2 c/a/m x = 894/20 = 44.70 goals per season. Median
CHAPTER 7
CONTINUOUS PROBABILITY DISTRIBUTIONS
SECTION EXERCISES
7.1 d/p/e Discrete probability distributions can be expressed as histograms where the height of the
vertical bars is the probability for the various values that the random variable can take
CHAPTER 6
DISCRETE PROBABILITY DISTRIBUTIONS
SECTION EXERCISES
6.1 d/p/e A random variable is described as "random" because we don't know ahead of time exactly
what value it will have following the experiment.
6.2 d/p/m
a. Continuous. This is an exact mea
CHAPTER 5
PROBABILITY: REVIEW OF BASIC CONCEPTS
SECTION EXERCISES
5.1 d/p/m This is a subjective probability, since it represents the degree to which the president believes
that an event will occur.
5.2 d/p/m The sample space consists of two possible outc
CHAPTER 4
DATA COLLECTION AND SAMPLING METHODS
SECTION EXERCISES
4.1 d/p/e Primary data are generated by the researcher for the purpose of studying the problem at hand;
secondary data already exist and are not generated for the sole purpose of studying th
CHAPTER 1
A PREVIEW OF BUSINESS STATISTICS
SECTION EXERCISES
1.1 d/p/e In ancient times, statistics was mainly employed for counting people or possessions in order
to facilitate taxation.
1.2 d/p/m Statistical methods are useful in all facets of business