Assignment 3: Living Situation
1
Assignment 3: Living Situation
Brandman University
Assignment 3: Living Situation
2
Intro
Most Americans ask themselves this question every year, should I sign another lease or
buy a place I can call home. In my personal l
The scores and their percents of the final grade for a statistics
student are shown below. What is the students mean score?
Score
Homework
Quizzes
Project
Presentation
Final exam
Percent of final grade
85
5%
80
35%
100
20%
90
15%
93
25%
SumProduct
89.00 <
BUSU 610 Data Driven Decision Making
Student Excel Skill Demonstration
Spring III 2011
Please read and follow these instructions carefully:
1 Enter your name here:
2 Go to Each Sheet
3 Enter your Excel formulas to display the results, where appropriate
4
Assignment 1: Defining the Problem
1
Assignment 1: Defining the Problem
Sarah Roberts
Brandman University
Assignment 1: Defining the Problem
2
Cox Enterprises, Inc. (CEI) consists of Cox Communications (CCI), Cox Automotive
(CAI) and Cox Media Group (CMI)
Textbook Assignment Week 2
Duplicate the chart for the Vehicle Sales chart on p 26 using the software
commands in section 1 of Chapter 2 (p 55)
80
70
60
50
40
30
20
10
0
Sedan
SUV
Compact
Truck
Hybrid
Percent of Vehicles Sold by Type
10%
5%
40%
15%
Sedan
Running Header: Motorola: The Iridium Project
Motorola: The Iridium Project
Aaron Burdt, Eva Hedger, Micah Piper,
Sarah Roberts and Marisa Sullivan
Brandman University
April 2, 2017
1
Motorola: The Iridium Project
2
Motorola: The Iridium Project
Have you
Assignment 3: Living Situations
1
Assignment 3: Living Situations
Sarah Roberts
Brandman University
Assignment 3: Living Situations
2
Abstract
This paper will analyze this students current living situation. This will be done while
considering the economic
Chapter 1 Connect Exercise 1 pg. 14
1. What is the level of measurement for each of the following variables?
a. Student IQ ratings: Interval
b. Distance students travel to class: Ratio
c. The jersey numbers of a sorority soccer team: Nominal
d. A students
The amount of cola in a 12-oz can is uniformly distributed between 11.96-12.05-oz.
a. What is the mean amount per can? 12.005
b. What is the standard deviation amount per can? .0260
c. What is the probability of selecting a can of cola and finding it has
Assignment 4: Putting Economic Analysis to Work
1
Assignment 4:
Putting Economic Analysis to Work
Sarah Roberts
Brandman University
Assignment 4: Putting Economic Analysis to Work
2
Introduction
San Diego Roots Collective was founded in November 2016. It
Refer to the Real Estate data, which reports information on homes sold in the Goodyear, Arizona, area during last ye
a. Develop a box plot. Estimate the first and third quartiles. Are there any outliers?
MIN
Q1
MEDIAN
Q3
MAX
125
172.5
235.15
258.75
345.3
Using sections 1 & 2 in the software commands on p 221, duplicate the excel output on p 209
0.8413447461
Refer to the Real Estate data. Use statistical software to compute the mean and the standard deviation of the selling prices
population. Select a samp
BUSU 610 Data Driven Decision Making
Student Excel Skill Demonstration
Please read and follow these instructions carefully:
1
Enter your name here:
2 Go to Each Sheet
3 Enter your Excel formulas to display the results, where appropriate
4 Skip the problem
31.
An auto insurance company reported the following information regarding the age of a driverand
the number of accidents reported last year. Develop a scatter diagram for the data and write a
brief summary.
Age
16
24
18
17
Accidents
4
2
5
4
Age
23
27
32
Chapter 1 Practice Test (Part 2-Problems, #2)
2. There are 14 freshman, 18 sophomores, 10 juniors, and 6 seniors enrolled in an introductory
finance class. Answer the following questions.
a. What is the level of measurement for this student data?
Ordinal
31)
The amount of cola in a 12-ounce can is uniformly distributed between 11.96 ounces and 12.05 ounces.
a.)
What is the mean amount per can?
Mean = 11.95+12.05/2 = 12.005
b.)
What is the standard deviation amount per can?
Standard deviation = (12.05-11.9
2.)
The Excel commands for the two-sample t-test on page 340 are:
a)
Welles
2
4
9
3
2
Atkins
3
7
5
8
4
3
t-Test: Two-Sample Assuming Equal Variances
Mean
Variance
Observations
Pooled Variance
Hypothesized Mean Difference
df
t Stat
P(T<=t) one-tail
t Criti
Chapter 2 Practice Test (Part 2-Problems, #1)
1. Consider these data on the selling prices ($000) of homes in the city of Warren, Pennsylvania,
last year.
Selling Price ($000)
120 up to 150
150 up to 180
180 up to 210
210 up to 240
240 up to 270
270 up to
Connect Exercises Chapter 1
1. What is the level of measurement for each of the following variables?
a. Student IQ ratings. (Interval)
b. Distance students travel to class. (Ratio)
c. The jersey numbers of a sorority soccer team. (Nominal)
d. A students s
52.
Refer to the 2010 Baseball data that reports information on the 30 Major League Baseball teams
for the 2010 season. Create a frequency distribution for the team payroll variable and answer
the following questions.
a. What is the typical payroll for a
63.
A sample of 25 undergraduates reported the following dollar amounts of entertainment
expenses last year:
684
763
710
681
688
731
711
736
722
771
698
693
723
701
743
737
738
717
722
752
696
710
721
697
a. Find the mean, median, and mode of this informa
1.)
0.841345
2.)
64311.09
z= -1.750686
46.)
Refer to the Real Estate data, which report information on the homes sold in the Goodyear, Arizona, area last year. U
Select a sample of 10 homes. Compute the mean and the standard deviation of the sample. Deter
Strengths
GW Pharmaceuticals
Experience in pharmaceutical industry
FDA approved cannabis based drug
Weaknesses
Federal oversight
Lacks whole plant entourage effect
Strengths
Capitalization of digital platform
Huge audience = top dollar advertising outl
Start
Continue with current
system
Establish new, email update
system
Efficiency
increased
Continue
improving
email
software
Increase output
efficiency
Efficiency
decreased
Go back to
old method
Chapter 7 #31 pg. 216
The amount ofThe amount ofThe amount ofThe amount ofThe amount ofThe amount ofThe amount of
a. What is the mean amount per can? 12.005
b. What is the standard deviation amount per can? .0260
c. What is the probability of selecting a