BSAD221 Difference Between a Population and A Sample Statistics Excel Project Requirements – Must know how to use excel – Be able to make a bar graph

BSAD221 Difference Between a Population and A Sample Statistics Excel Project Requirements

– Must know how to use excel

– Be able to make a bar graph based off of the information given as well

Here is the information I would like for you to use to base the project off of.

50 Most Dangerous Cities In The US

State City Population Violent Crimes Per 1000

1

Alabama

Anniston

22,205

33.10

2

Missouri

Wellston

2,326

30.09

3

Louisiana

Monroe

49,677

30.05

4

Georgia

Oakwood

4,218

29.63

5

Alabama

Bessemer

26,592

28.69

6

New Mexico

Espanola

10,030

26.72

7

Florida

Opa Locka

16,835

22.22

8

Alaska

Bethel

6,522

21.62

9

Florida

Cocoa

17,825

20.70

10

Michigan

Detroit

669,673

20.47

11

South Carolina

Hartsville

7,837

19.65

12

Missouri

St. Louis

314,507

19.13

13

South Carolina

Dillon

6,648

19.10

14

Georgia

College Park

14,724

18.95

15

Alabama

Alexander City

14,695

18.85

16

South Carolina

Lake City

6,809

18.80

17

Arkansas

West Memphis

24,818

18.58

18

Louisiana

Alexandria

47,936

18.42

19

Michigan

Muskegon Heights

10,785

18.36

20

Tennessee

Memphis

656,434

18.20

21

North Carolina

Lumberton

21,683

18.12

22

Alabama

Selma

19,283

18.05

23

Michigan

Benton Harbor

9,963

17.97

24

Maryland

Baltimore

618,385

17.80

25

Delaware

Wilmington

72,183

17.80

26

Texas

Robstown

11,596

17.42

27

Michigan

Highland Park

10,810

17.39

28

New Mexico

Gallup

23,528

17.26

29

New Mexico

Belen

7,127

17.12

30

Alabama

Prichard

22,299

17.00

31

Missouri

Bel-Ridge

2,719

16.92

32

South Carolina

Myrtle Beach

31,864

16.88

33

Tennessee

Brownsville

9,795

16.85

34

Missouri

Pine Lawn

3,447

16.83

35

Missouri

Kansas City

478,364

16.55

36

Ohio

Cleveland

386,227

16.31

37

Michigan

Ecorse

9,213

16.17

38

Alabama

Lanett

6,451

16.12

39

Arkansas

Pine Bluff

43,976

16.03

40

Florida

Belle Glade

18,405

16.03

41

Michigan

Flint

97,548

15.84

42

South Carolina

Camden

7,132

15.70

43

Alabama

Scottsboro

14,711

15.57

44

West Virginia

Charleston

49,429

15.52

45

Wisconsin

Milwaukee

600,193

15.33

46

Arkansas

Little Rock

198,800

15.31

47

Louisiana

Opelousas

16,557

15.10

48

Indiana

Elkhart

52,505

15.07

49

Alabama

Boaz

9,729

15.01

50

Texas

Bellmead

10,212

14.88 BSAD 221 – PROJECT – SUMMARY INSTRUCTIONS (PROF. DOYLE):
1 – Due Tuesday, May 7th at 1:30 pm (Charlton Room 224 or Room 038 in person)
2 – Your data sample must be pre-approved by Prof Doyle by Thurs., April 11th
3 – See pages 2 & 3 for detailed instructions
Part #1: Research Narrative
•
•
•
Describe/discuss the difference between a population and a sample. Give examples.
Describe/discuss various types of sampling methods (Ch 7 and research)
Explain the difference between non-probability based vs. probability-based
methods for collecting a sample from a population
o How would you ensure the sample was from a probability method?
o Share the sampling method you might use
Part #2: Data Analysis
•
•
•
•
•
Choose a sample of 30-50 observations with three quantitative variable columns
Complete data statistics for each variable
Chart each variable
Compute a 95% confidence interval
Research articles/resources similar to your data topic
•
Complete a narrative report
o that interprets/describes your data (okay to copy and paste charts and/or
data stats from Excel’s Data Analysis Tool, but be sure the format of your
report remains readable and professional
o that speaks to what the charts tell you/show the reader
o that discusses your related articles and how they compare to your results
as appropriate
Part #3: Raw Data
•
Print your raw data and other Excel files and put in an Appendix to your report
Part #4: Citations
•
Use APA style
SUBMIT YOUR PROJECT IN PRINTED HARDCOPY (COLOR PREFERRED) TO
YOUR INSTRUCTOR , AS WELL AS ELECTRONICALLY VIA BLACK BOARD
BSAD221/Business Statistics, Spring 2019 Project—Professor Doyle
Page 1 of 3
BSAD 221—Spring 2019
Project #2 – Part 1—This Part is worth 50 Points*
Due by: Tuesday, MAY 7th (By 1:30 P.M.) Extensions of due date/time will NOT be granted.
Objective: To demonstrate your understanding as to the types of Datasets and the various Sampling
Collection Methods
I.
Based on your knowledge of Data and Sampling, please present discussion as to the difference
between a Sample and a Population, including a relevant example—using the following as
Suggested Headings, in grammatically-complete construction, to create effective, substantive
paragraphs, as well as Proper Citations/Complete Reference Information, as per APA Style:
Data Represented By a Population
❑ Please provide description, discussion, and rationale as to what constitutes a Population
❑ Please include Relevant Example(s) [your BSAD221 Project 2 Dataset, can be used for instance]
Data Represented By a Sample
❑ Please provide description, discussion, and rationale as to what constitutes a Sample
❑ Please include Relevant Example(s) [your BSAD221 Project 2 Dataset, can be used for instance]
II.
With respect to your knowledge of the various types of Sampling Methods, please present discussion
and explanation as to the following Data Collection Methods: Non-Probability and Probabilitybased Methods for collecting a Sample from a Population – Using the following suggested
Headings:
Data Collection Methods – Non-Probability v. Probability-based
❑ Please provide descriptions and explanation as to the difference between Non-Probability and Probability
Methods
Using a Probability-based Method
❑ Please discuss how would you collect a Sample to ensure it was a Probability-based method
❑ Please specify the Sampling Method(s) would you use, and how would you employ it (them)
Other Comments:
➢
This part of the project is an individual assignment and will contribute toward 20% of your course grade
*Evaluation:
High-Quality Discussion/Explanation – Sample, Population, Sampling Methods
Effective Construction of Rationale/Discussion, Spelling, Grammar, Punctuation
40 Points
10 Points
*Your Evaluation will based on measurable criteria (e.g., numerical continuum—from Exemplary to Failure
for Critical Thinking work; alphabetical scoring—from A to F Scale for Exams, etc.) that provide evidence as to
your consistently (or inconsistently) achieving (or failing to achieve) specific academic competencies outlined
within the learning objectives. In particular, Case Analyses, Essay responses, all Written Reports, and
Verbal Discussion will be sources (i.e., Learning Events), from which Critical Thinking will be assessed, as
part of Grading Criteria.
BSAD221/Business Statistics, Spring 2019 Project—Professor Doyle
Page 2 of 3
BSAD 221—Spring 2019
Project #2 – Part 2—This Component is worth 100 points*
Due by: Tuesday, MAY 7th (By 1:30 P.M.)
Objective: To demonstrate proficiency in Data Collection, Descriptive Statistics, and Inferential Statistics
Requirements:
1. Please locate a set of Data from an authentic Online or Text-based source (e.g. Websites identified
during class) that is of interest to you. The Data Set must include at least 30 Observations and at
least 3 Quantitative Variables—Please refer to the Data Sources Provided and/or A/S/W Text.
2. Please summarize the Data Set using Descriptive Statistics Tools {i.e., Tabular, Graphical, and
Numerical representation} discussed in class. If your Data Set includes more than 3 Variables,
please select 3 to analyze. At a minimum, each variable analyzed should have one Graphical
depiction and a Set of Descriptive Statistics.
3. Please create a Confidence Interval to estimate the population parameter {i.e., Mean or Proportion}
for the variables selected above.
4. Please locate other Data related to your Data Set (e.g. relevant articles about your topic, a comparable
Data Set) and evaluate this additional information in conjunction with your Data Set. You must have
a minimum of 2 related items incorporated into your report.
Please prepare a typed-written Report summarizing the above. Your Report should include the following
sections:
1. Description of the Data {i.e., what it is, the types of variables, the source}—including Citations
2. Description of Statistical Analysis performed {i.e., Descriptive and Inferential}
3. Description and Interpretation of the Results
4. Description and Interpretation of articles and related source material—including relevant citations
5. Overall Conclusions on your Data Set
6. Reference List—APA Style
7. Appendix: Statistical Output, Tables, Charts, etc.
Other Comments:
➢ Please present a copy of your selected Data Set to Professor Doyle by Thursday, April 11, 2019
➢ All sources [e.g., Websites, Articles (Online and Library-based), etc.] must be fully Cited within the Report,
and completely listed within the References Section, as per APA Style
➢ This is an Individual Project that must be completed Individually—ONLY, and will contribute toward 20%
of your course grade..
*Evaluation:
Selected Data Set
Written Report {i.e., Accurate content knowledge applied and explained/Item’s 1-5 above}
Presentation of Statistical Analyses {i.e., Visual Quality of Appendix/Item 6 above}
Sentence Structure, Spelling, Grammar, Punctuation, Organized Construction/Headings, etc.
Accurate Citations and Complete Reference Information—APA Style Format
15 Points
50 Points
20 Points
10 Points
5 Points
*Your Evaluation will based on measurable criteria (e.g., numerical continuum—from Exemplary to
Failure for Critical Thinking work; alphabetical scoring—from A to F Scale for Exams, etc.) that
provide evidence as to your consistently (or inconsistently) achieving (or failing to achieve) specific
academic competencies outlined within the learning objectives. In particular, Case Analyses, Essay
responses, all Written Reports, and Verbal Discussion will be sources (i.e., Learning Events), from
which Critical Thinking will be assessed, as part of Grading Criteria.
UPLOAD both your MS Word and your MS Excel files to
Black Board and print me a color hardcopy of both.
BSAD221/Business Statistics, Spring 2019 Project—Professor Doyle
Page 3 of 3

Purchase answer to see full
attachment