Be on time

Please be on time or before. Only bid it if you can handle it, gimme proper answers

I have business analytics homework need help to complete.

The assignment needs to be completed help using excel and post a pictures if needed or images in the word doc attached in the summary page. (PAGE 1). The Word document the summary page is where you answer or post the answer and the second page is the problems in the same documents.

Age
27
22
43
49
30
19
24
42
44
40
32
31
34
63
25
25
Credit Score
638
506
712
813
633
518
513
810
798
837
587
658
688
827
657
671
Gender
Male
Male
Male
Female
Female
Female
Female
Male
Female
Female
Male
Female
Female
Male
Male
Male
58
64
40
23
57
38
48
52
45
30
62
34
38
41
32
24
55
62
57
39
32
50
50
57
25
34
32
49
27
833
770
821
534
817
789
818
755
832
650
759
610
849
819
657
516
820
713
774
788
571
838
799
841
665
759
676
796
700
Male
Male
Female
Male
Female
Female
Female
Female
Male
Female
Male
Female
Female
Female
Male
Female
Female
Male
Male
Female
Male
Female
Female
Male
Female
Female
Female
Male
Female
28
24
41
45
21
601
545
802
821
489
Female
Male
Female
Female
Male
Age
Percent
Age
Credit Score
Male
Female
Total
Min
Max
Range
Mean
Median
Mode(s)
Variance
St. Dev
Covariance
Correlation
Coefficient
of Variation
SK
NAME _______________________________
SUMMARY SHEET GSB 519 – Assignment 2
1. This statement is __________________. If FALSE, the following statement is correct:
______________________________________________________________________________
2. This statement is __________________. If FALSE, the following statement is correct:
______________________________________________________________________________
3. This statement is __________________. If FALSE, the following statement is correct:
______________________________________________________________________________
4. This statement is __________________. If FALSE, the following statement is correct:
______________________________________________________________________________
5. This statement is __________________. If FALSE, the following statement is correct:
______________________________________________________________________________
6. This statement is __________________. If FALSE, the following statement is correct:
______________________________________________________________________________
7. I select _______________
8. The best answer is _______
9. The best answer is _______
10. The best answer is _______
11. The best answer is _______
12. You can just paste a picture/table from excel here
of the answers.
a) Count of Males and Females
b) Percent of Male and Females
c) For both Age and Credit Score find:
d) Find the minimum
e) Find the maximum
f) Find the range
g) Find the mean to two decimal places
h) Find the median to two decimal places
i) Find the mode(s)
j) Find the variance
k) Find the standard deviation
l) Find the Covariance
m) Find the correlation coefficient
n) Find the coefficient of variation
o) Find the skewness
Age
Percent
Age
Credit
Score
Male
Female
Total
Min
Max
Range
Mean
Median
Mode(s)
Variance
St. Dev
COV
Correl
CV
SK
13. Paste your Age Histogram here
14. Paste your Credit Score Histogram here
15. Paste your graph of the amount of men and women here.
GSB519 WEEK 2
1. True or False: You can find the mean for a nominal variable.
2. True or False: Discrete variables are considered categorical variables.
3. True or False: Discrete variables can be thought of as countable.
4. True or False: Probability sampling methods are preferred over non-probability sampling methods
because we can usually use those samples to infer something about the population they represent.
5. True or False: We represent the mean of population data with 𝑥̅ .
6.) True or False. Stratified sampling attempts to attempts to ensure that subgroups are represented in
same proportion as population.
7). True or False: There is no wrong answer to this question you will get full credit for any answer. I am
trying to gauge interest. I would like to learn more ways to work in excel, e.g. learning about ways to clean
data in excel, using pivot tables, working on visualizing data.
8.) Randomness is an important part of sampling because:
a) the randomness gives us the best chance that the sample is a good representative of the
population.
b) we won’t know what results we will get.
c) No answer. It is not important.
d) we can then use it to infer things about the population.
e) Both a and d are correct.
9.) The information on a Pie Chart can also be represented by a:
a) line chart
b) scatter plot
c) waterfall
d) bar chart
10). What chart is good at comparing categories that have a natural order to them?
a) column chart
b) scatter plot
c) donut chart
d) bubble chart
11). The ___________ is NOT sensitive to outliers.
a) mean
b) range
c) average
d) median
12). Download the Central Tendency.xlsx spreadsheet from D2L. Calculate the following statistics:
Count of Males and Females
Percent of Males and Females
For both Age and Credit Score find:
Find the minimum
Find the maximum
Find the range
Find the mean to two decimal places
Find the median to two decimal places
Find the mode(s)
Find the variance
Find the standard deviation
Find the Covariance
Find the correlation coefficient
Find the coefficient of variation
Find the skewness
13). Create a histogram of age with the bin width set to 10 and underflow bin set to 20.
14) Create a histogram of credit scores with the bin width set to 100 and underflow bin set to 500.
15) Create a graph to display the amount of men and women in the data.