BUS 308 Inspiring Minds/newtonhelp.com

1
BUS 308 Inspiring Minds/newtonhelp.com
2
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Entire Course (New)
• For more course tutorials visit
• www.newtonhelp.com
•  
• BUS 308 Week 2 Problem Set
• BUS 308 Week 3 Problem Set (Anova)
• BUS 308 Week 4 Problem Set (Regression and
  Correlation)
• BUS 308 Week 5 Final Paper Statistics Reflection
  (2 Papers)
• BUS 308 Week 1 DQ 1
• BUS 308 Week 1 DQ 2
• BUS 308 Week 2 DQ 1
• BUS 308 Week 2 DQ 2

3
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 1 DQ 1
• For more course tutorials visit
• www.newtonhelp.com
•  
• Part Two Data Characteristics
• Read Lecture One on descriptive data and review
  the Employee Data . Be sure to familiarize
  yourself with the different variables shown on
  the Data tab. In this course, we will be using
  the Employee Data and statistical tools to answer
  a single research question In our BUS308
  company, are the males and females paid equally
  for equal work?

4
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 1 DQ 2
• For more course tutorials visit
• www.newtonhelp.com
•  
• DQ 2 Webliography
• Post a question that you had related to the
  material this week. Conduct research to provide
  the answer to the question and provide the source.

5
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 1 Problem Set
• For more course tutorials visit
• www.newtonhelp.com
•  
• 1. For assistance with these calculations, see the
   Recommended Resources for Week One. Measurement i
  ssues. Data, even numerically code variables, can 
  be one of 4 levels  nominal, ordinal, interval, o
  r ratio. It is important to identify which level a
   variable is, as this impacts the kind of analysis
   we can do with the data. For example, descriptive
   statistics such as means can only be done on inte
  rval or ratio level data. Please list, under each 
  label, the variables in our data set that belong i
  n each group..
• 2. The first step in analyzing data sets is to fin
  d some summary descriptive statistics for key vari
  ables. For salary, compa, age, Performance Rating,
   and Service find the mean and standard deviation
   for 3 groups overall sample, Females, and Males.
   You can use either the Data Analysis Descriptive 
  Statistics tool or the Fx average and stdev func
  tions. Note Place data to the right, if you use D
  escriptive statistics, place that to the right as 
  well 

6
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 1 Quiz (2 Set)
• For more course tutorials visit
• www.newtonhelp.com
•  
• Question 1.  Calculating the median requires data
  of at least what level ?
• Question 2.  If sales data are reported in dollar
  values, what is the scale of the data ?
• Question 3.  Empirical probability is
• Question 4.     A probability is found by
  dividing the number of possible outcome (0) by
  the number of successes (e)P o/e.

7
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 2 DQ 1
• For more course tutorials visit
• www.newtonhelp.com
•  
• DQ 1 Hypothesis Testing / T-tests / F-test
• Although the initial post is due on Day 5, you
  are encouraged to start working on it early, as
  it is a three-part discussion that should be
  completed in sequential order.
• Part One Hypothesis Testing

8
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 2 DQ 2
• For more course tutorials visit
• www.newtonhelp.com
•  
• Post a question that you had related to the
  material this week. Conduct research to provide
  the answer to the question and provide the source

9
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 2 Problem Set
• For more course tutorials visit
• www.newtonhelp.com
•  
• Before starting this assignment, make sure the
  the assignment data from the Employee Salary Data
  Set file is copied over to this Assignment file.
  You can do this either by a copy and paste of all
  the columns or by opening the data file, right
  clicking on the Data tab, selecting Move or Copy,
  and copying the entire sheet to this file (Weekly
  Assignment Sheet or whatever you are calling your
  master assignment file).

10
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 2 Quiz (3 Set)
• For more course tutorials visit
• www.newtonhelp.com
•  
• Question 1. To find the z-score of a value, which
  Excel function could be used?
• Question 2.  Which statement is not true?
• Question 3.  What is the alternate hypothesis in
  a problem where sales group two is predicted to
  be significantly less productive than sales
  group one? 
• Question 4.  Using the T-test Two-sample
  Assuming Equal Variances test, the output can
  provide 

11
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 3 DQ 1
• For more course tutorials visit
• www.newtonhelp.com
•  
• Part One Multiple Testing
• Read Lecture Seven. The lectures from last week
  and Lecture Seven discuss issues around using a
  single test versus multiple uses of the same
  tests to answer questions about mean equality
  between groups. This suggests that we need to
  masteror at least understanda number of
  statistical tests. Why cant we just master a
  single statistical testsuch as the t-testand
  use it in situations calling for mean equality
  decisions? (This should be started on Day 1.) 
•  

12
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 3 DQ 2
• For more course tutorials visit
• www.newtonhelp.com
•  
• DQ 2 Webliography
• Post a question that you had related to the
  material this week. Conduct research to provide
  the answer to the question and provide the source.

13
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 3 Problem Set (Anova)
• For more course tutorials visit
• www.newtonhelp.com
•  
• During this week, we will look at ways of testing
  multiple (more than two) data samples at the same
  time.
•  
• We will continue to use the data and assignment
  file that we opened in Week 2, we just move on to
  the Week 3 tab.

14
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 3 Quiz (3 Set)
• For more course tutorials visit
• www.newtonhelp.com
•  
• BUS 308 Week 3 Quiz
• Question 1.  A single factor ANOVA output
  includes information on
• Question 2.  ANOVA tests for variance differences
• Question 3.  Excels single factor ANOVA does not
  have a related Effect Size measure associated
  with it.

15
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 4 DQ 1
• For more course tutorials visit
• www.newtonhelp.com
•  
• Part One Correlation
• Read Lecture Ten. Lecture Ten introduces the idea
  that different variables may move
  togethersometimes due to causation and at other
  times due to an unknown influence. An example
  involves the perfect (1.0) correlation between
  annual number of rum barrels imported into the
  New England region of the U.S. between the years
  1790 and 1820 and the number of churches built
  each of those years (citation lost).

16
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 4 DQ 2
• For more course tutorials visit
• www.newtonhelp.com
•  
• DQ 2 Webliography
• Post a question that you had related to the
  material this week. Conduct research to provide
  the answer to the question and provide the source.

17
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 4 Problem Set (Regression and
  Correlation)
• For more course tutorials visit
• www.newtonhelp.com
•  
• Problem Set Week Four 
• This week we get to answer our equal pay for
  equal work question by looking at relationships
  between and among the different variables.
• The first question this week looks at
  correlations and the creation of a correlation
  table for our variables.  The second question
  asks for a regression equation showing how the
  different variables impact the compa-ratio
  measure.

18
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 4 Quiz (3 Set)
• For more course tutorials visit
•  
• www.newtonhelp.com
•  
• BUS 308 Week 4 Quiz
•  
• Question 1.  The t Stat value is used to
  determine the statistical significance of each of
  the variables listed in a regression analysis.
• Question 2.  A correlation of .90 and above is
  generally considered too strong to be of any
  practical significance.
• Question 3.  A p-value of 9.22E-36 equals
  0.00000000000000000000000000000000000922 and is
  less than .05

19
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 5 DQ 1
• For more course tutorials visit
• www.newtonhelp.com
•  
• Part One Confidence Intervals
• Read Lecture Thirteen. Lecture Thirteen
  introduces you to confidence intervals. What is a
  confidence interval, and why do some prefer them
  to single point estimates? Ask your manager what
  is preferred and why? What are the strengths and
  weaknesses of using confidence intervals in
  making decisions? (This should be started on Day
  1.)
•  

20
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 5 DQ 2
• For more course tutorials visit
• www.newtonhelp.com
•  
• What are common mistakes in linear regression
  analysis? 

21
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 5 Final Paper Statistics Reflection
  (2 Papers)
• For more course tutorials visit
• www.newtonhelp.com
•  
• This tutorial contains 2 Different Papers
•  
• The final paper provides you with an opportunity
  to integrate and reflect on what you have learned
  during the class.
• The question to address is What have you
  learned about statistics? In developing your
  responses, consider at a minimum and discuss
  the application of each of the course elements in
  analyzing and making decisions about data (counts
  and/or measurements). 

22
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 5 Problem Set
• For more course tutorials visit
• www.newtonhelp.com
•  
• 1. Create a correlation table for the variables in
   our  (Use analysis ToolPak or StatPlusmac LE fun
  ction Correlation). 
• a. Reviewing the data levels from week 1, what var
  iables can be used in a Pearsons Correlation Tabl
  e (which is what Excel produces)? 
• b. Place the table here. 
• c. Using r approximately .28 as the significant r
   value (at p  .05) for a correlation between 50 v
  alues, what variables are significantly related to
   salary? To compa? 
• d. Looking at the above correlations  both signif
  icant or not  are there any surprises  by that I
   mean any relationships you expected to be meaning
  ful and are not, and vice-versa? 

23
BUS 308 Inspiring Minds/newtonhelp.com

• BUS 308 Week 5 Quiz (3 Set)
• For more course tutorials visit
• www.newtonhelp.com
•  
• BUS 308 Week 5 Quiz 
• Question 1.  Compared to the ANOVA test, Chi
  Square procedures are not powerful (able to
  detect small differences).
• Question 2.  In confidence intervals, the width
  of the interval depends only on the variation
  within the data set.
• Question 3.  The percent confidence interval is
  the range having the percent probability of
  containing the actual population parameter.

24
BUS 308 Inspiring Minds/newtonhelp.com