Stats and explanatiom

profilejohnnyjohnny
team_-2.docx
Home>Mathematics homework help>Stats and explanatiom

Research Question Blue Rectangle

January 19, 2015

Running head: RESEARCH QUESTION BLUE RECTANGLE

1

RESEARCH QUESTION BLUE RECTANGLE

4

Research Question Blue Rectangle

A regional manager for Blue Rectangle Company visited Wonderfulsville Research Development group seeking assistance with maximizing profits between the DVD rental kiosk locations in town; they are located on Highway 10, and near Shackelford Road. Manager stated that his kiosks are equipped to hold 40 DVDs of each selection per location, however he choose to only have 20 per kiosk based on past rental history and data. He provided rental data per location for the past three weeks for review (See below) and wanted to see if it would be beneficial to move certain selections from one location to the other.

Research Question and Hypothesis Statement

Wonderfulsville Research Development group has developed the research question and hypothesis statements based on information presented by Blue Rectangle’s regional manager. The research question

Is there a correlation in movie selection (dependent variable) based on kiosk location (independent variable). The dependent variable is movie selection, which is an attribute (University of Phoenix, 2014). The independent variable is location, which is also an attribute (University of Phoenix, 2014).

Hypothesis statements

1. There is no correlation in movie selection (DV) based on kiosk location (IV) (University of Phoenix, 2014).

2. There is a correlation in movie selection (DV) based on kiosk location (IV) (University of Phoenix, 2014).

Conclusion

Wonderfulsville Research Development group has taken on a new research assignment; the team has been hired to determine ways to maximize profits through research between the two kiosks located in Wonderfulsville. Research question and two hypothesis statements were developed and team is currently analyzing rental data that Blue Rectangle’s regional manager has provided.

Reference

University of Phoenix. (2014). Research Question Two Variable Handout. Retrieved from University of Phoenix, ACC/561 website.

Blue Rectangle

Data.xlsx

data

Selection Category # Times Rented From Hwy 10 28 Dec-3 Jan # Times Rented From Shackelford 28 Dec-3 Jan # Times Rented From Hwy 10 4-10 Jan # Times Rented From Shackelford 4-10 Jan # Times Rented From Hwy 10 11-17 Jan # Times Rented From Shackelford 11-17 Jan Total number of Times Movie was rented Total Hwy 10 Shackelford # Times Rented From Hwy 10 28 Dec-3 Jan # Times Rented From Shackelford 28 Dec-3 Jan # Times Rented From Hwy 10 4-10 Jan # Times Rented From Shackelford 4-10 Jan # Times Rented From Hwy 10 11-17 Jan # Times Rented From Shackelford 11-17 Jan
A Walk Among the Tombstones Action 2 9 1 11 2 10 35
The Maze Runner Action 3 8 0 15 4 11 41
No Good Deed Action 4 11 4 19 2 17 57
The Equalizer Action 5 11 3 15 5 12 51
Dawn of the Plannet of the Apes Action 1 10 2 14 1 11 39
Guardians of the Galaxy Action 17 5 19 5 18 4 68
Teenage Mutant Nijia Turtles Action 22 7 20 8 21 10 88
Into the Storm Action 2 10 0 11 3 12 38
When the Game Stands Tall Action 1 9 3 12 4 18 47
The Scorpion King 4 Quest for Power Action 1 11 2 14 4 12 44
Revenge of The Green Dragons Action 2 18 5 11 1 12 49
Drive Hard Action 4 14 2 16 2 11 49 606 192 414 64 123 61 151 67 140
How to Train Your Dragon 2 Cartoon 2 14 1 14 5 11 47
Frozen Cartoon 29 4 31 6 24 3 97
Ribbit Cartoon 12 5 14 2 16 4 53 197 134 63 43 23 46 22 45 18
Lets be Cops Comedy 4 11 1 13 1 12 42
Land Ho Comedy 2 10 2 16 4 14 48
Tammy Comedy 2 9 1 19 1 12 44 134 18 116 8 30 4 48 6 38
This is Where I Leave You Drama 2 11 8 14 4 12 51
Men, Women, & Children Drama 3 9 4 12 3 18 49
BoyHood Drama 4 12 2 14 1 22 55
If I Stay Drama 4 15 4 15 1 15 54
Dolphin Tale 2 Drama 21 5 23 2 22 1 74
Racing Hearts Drama 6 17 4 11 5 15 58
Love is Strange Drama 1 10 1 12 3 13 40
Argo Drama 4 15 9 12 1 15 56
Reclaim Drama 5 14 5 10 4 11 49
I Orgins Drama 7 14 2 11 9 12 55
Calvary Drama 4 11 1 10 2 15 43 584 179 405 61 133 63 123 55 149
Jessabelle Horror 2 19 0 14 2 17 54
Finding Keepers Horror 6 12 4 12 2 12 48 102 16 86 8 31 4 26 4 29
Total Rentals 184 340 178 370 177 374 1623 1623 539 1084
Hwy 10 total 539
Shackelford 1084
Movies. (2014). Retrieved from http://www.redbox.com/movies

graphing

28 Dec - 17 Jan Hwy 10 Shackford
Action 192 414
Cartoon 134 63 Renting Time Line
Comedy 18 116
Drama 179 405
Horror 16 86
539 1084
Renting Time Line
28 Dec-3 Jan 184 340
4-10 Jan 178 370
11-17 Jan 177 374
Total 539 1084
Hwy10 Category by location
By Category/Date 28 Dec-3 Jan 4-10 Jan 11-17 Jan HWY 10
Action 64 61 67
Cartoon 43 46 45
Comedy 8 4 6
Drama 61 63 55
Horror 8 4 4
Shackford
By Category/Date 28 Dec-3 Jan 4-10 Jan 11-17 Jan
Action 123 151 140
Cartoon 23 22 18
Comedy 30 48 38
Drama 133 123 149
Horror 31 26 29
Shackford
Total Movie rental from 28 Dec - 17 Jan
Hwy 10 Action Cartoon Comedy Drama Horror 192 134 18 179 16 Shackford Action Cartoon Comedy Drama Horror 414 63 116 405 86 Hwy 10 28 Dec - 17 Jan 539 Shackford 28 Dec - 17 Jan 1084 Hwy 10 28 Dec-3 Jan 4-10 Jan 11-17 Jan 184 178 177 Shackford 28 Dec-3 Jan 4-10 Jan 11-17 Jan 340 370 374 Action 28 Dec-3 Jan 4-10 Jan 11-17 Jan 64 61 67 Cartoon 28 Dec-3 Jan 4-10 Jan 11-17 Jan 43 46 45 Comedy 28 Dec-3 Jan 4-10 Jan 11-17 Jan 8 4 6 Drama 28 Dec-3 Jan 4-10 Jan 11-17 Jan 61 63 55 Horror 28 Dec-3 Jan 4-10 Jan 11-17 Jan 8 4 4 Action 28 Dec-3 Jan 4-10 Jan 11-17 Jan 123 151 140 Cartoon 28 Dec-3 Jan 4-10 Jan 11-17 Jan 23 22 18 Comedy 28 Dec-3 Jan 4-10 Jan 11-17 Jan 30 48 38 Drama 28 Dec-3 Jan 4-10 Jan 11-17 Jan 133 123 149 Horror 28 Dec-3 Jan 4-10 Jan 11-17 Jan 31 26 29

Probability

HWY 10 Shackelford
2 9
3 8 HWY 10 Shackelford
4 11
5 11 Mean 5.80 Mean 11.62
1 10 Standard Error 0.7 Standard Error 0.4395
17 5 Median 3 Median 12
22 7 Mode 2 Mode 11
2 10 Standard Deviation 7.050 Standard Deviation 4.1465
1 9 Sample Variance 49.7078073866 Sample Variance 17.1933094995
1 11 Kurtosis 2.9051260255 Kurtosis 0.3769057385
2 18 Skewness 1.9550862222 Skewness -0.4058617658
4 14 Range 31 Range 21
2 14 Minimum 0 Minimum 1
29 4 Maximum 31 Maximum 22
12 5 Sum 539 Sum 1034
4 11 Count 93 Count 89
2 10 Confidence Level(95.0%) 1.4520077972 Confidence Level(95.0%) 0.8734659
2 9
2 11 LOW 4.3436911276 LOW 10.7445116281
3 9 HIGH 7.2477067219 HIGH 12.4914434281
4 12
4 15
21 5
6 17
1 10
4 15
5 14
7 14
4 11
2 19
6 12
1 11
0 15
4 19
3 15
2 14
19 5
20 8
0 11
3 12
2 14
5 11
2 16
1 14
31 6
14 2
1 13
2 16
1 19
8 14
4 12
2 14
4 15
23 2
4 11
1 12
9 12
5 10
2 11
1 10
0 14
4 12
2 11
4 4
2 10
5 12
1 18
18 12
21 12
3 11
4 11
4 3
1 4
2 12
5 14
24 12
16 12
1 18
4 22
1 15
4 1
3 15
1 13
1 15
22 11
5 12
3 15
1 17
4 12
9
2
2
2
539 1034