Question
In: Statistics and Probability
Please finish the following assignments in Excel. 1. Compute the following descriptive statistics for “TV Advertising...
Please finish the following assignments in Excel.
1. Compute the following descriptive statistics for “TV Advertising Spending”
– Mean
– Median
– Skewness
2. Relationship between AD spending and Consumer Preference:
– Draw a scatter plot of two variables.
– Compute a correlation coefficient
– How do you think about the correlation between the two variables?
| TV Advertising Spending (Mil. $) | Consumer Preference Rating | |
| Company 1 | 3.99 | -1.29 |
| Company 2 | 2.68 | 0.22 |
| Company 3 | 3.00 | 0.12 |
| Company 4 | 4.48 | -0.72 |
| Company 5 | 3.44 | 0.61 |
| Company 6 | 2.99 | 0.89 |
| Company 7 | 3.74 | 1.65 |
| Company 8 | 4.75 | -1.64 |
| Company 9 | 4.21 | -1.59 |
| Company 10 | 3.86 | -0.72 |
| Company 11 | 2.51 | 1.01 |
| Company 12 | 2.58 | -1.39 |
| Company 13 | 3.84 | -0.59 |
| Company 14 | 4.19 | -0.60 |
| Company 15 | 2.90 | 0.88 |
| Company 16 | 4.55 | -1.78 |
| Company 17 | 4.69 | -3.09 |
| Company 18 | 3.71 | 1.23 |
| Company 19 | 3.83 | -0.43 |
| Company 20 | 3.22 | -0.52 |
| Company 21 | 3.82 | -0.01 |
| Company 22 | 3.27 | 0.07 |
| Company 23 | 2.96 | -0.43 |
| Company 24 | 1.63 | -0.16 |
| Company 25 | 1.09 | -0.79 |
| Company 26 | 2.18 | 0.68 |
| Company 27 | 3.66 | -0.15 |
| Company 28 | 2.67 | -0.38 |
| Company 29 | 2.53 | -0.23 |
| Company 30 | 1.81 | -0.08 |
| Company 31 | 2.58 | 0.02 |
| Company 32 | 2.24 | -2.04 |
| Company 33 | 3.10 | 1.19 |
| Company 34 | 3.29 | 2.26 |
| Company 35 | 4.67 | -2.41 |
| Company 36 | 3.04 | 0.67 |
| Company 37 | 2.48 | -1.82 |
| Company 38 | 1.71 | -2.15 |
| Company 39 | 3.18 | 1.02 |
| Company 40 | 2.46 | 2.18 |
| Company 41 | 1.67 | -0.41 |
| Company 42 | 2.16 | -1.20 |
| Company 43 | 2.09 | 0.46 |
| Company 44 | 1.56 | -0.72 |
| Company 45 | 3.52 | 0.15 |
| Company 46 | 4.25 | -2.05 |
| Company 47 | 4.62 | 0.41 |
| Company 48 | 3.82 | -0.63 |
| Company 49 | 2.41 | 0.11 |
| Company 50 | 2.85 | 0.12 |
| Company 51 | 3.08 | 0.09 |
| Company 52 | 2.30 | -0.59 |
| Company 53 | 4.41 | -0.73 |
| Company 54 | 3.47 | 1.01 |
| Company 55 | 2.47 | 0.90 |
| Company 56 | 2.28 | 1.34 |
| Company 57 | 2.61 | 0.09 |
| Company 58 | 2.69 | 0.09 |
| Company 59 | 2.36 | 1.28 |
| Company 60 | 2.67 | 0.35 |
| Company 61 | 4.70 | -2.27 |
| Company 62 | 3.26 | -1.11 |
| Company 63 | 2.30 | 1.57 |
| Company 64 | 4.06 | -0.70 |
| Company 65 | 1.84 | -1.28 |
| Company 66 | 3.59 | 1.67 |
| Company 67 | 4.32 | -0.40 |
| Company 68 | 2.74 | 1.77 |
| Company 69 | 5.28 | -2.71 |
| Company 70 | 3.22 | 1.32 |
| Company 71 | 3.16 | 1.30 |
| Company 72 | 2.65 | 1.29 |
| Company 73 | 2.68 | 2.69 |
| Company 74 | 4.59 | -0.80 |
| Company 75 | 2.41 | -0.39 |
| Company 76 | 2.22 | 0.42 |
| Company 77 | 3.68 | -0.43 |
| Company 78 | 3.06 | 1.97 |
| Company 79 | 3.27 | 1.91 |
| Company 80 | 3.04 | 0.31 |
| Company 81 | 3.05 | 1.84 |
| Company 82 | 3.07 | 2.21 |
| Company 83 | 4.00 | -1.00 |
| Company 84 | 2.15 | 1.54 |
| Company 85 | 3.19 | 1.43 |
| Company 86 | 1.87 | -1.03 |
| Company 87 | 3.58 | -0.61 |
| Company 88 | 3.97 | 0.06 |
| Company 89 | 4.03 | -0.54 |
| Company 90 | 3.49 | 1.54 |
| Company 91 | 2.19 | 1.30 |
| Company 92 | 1.73 | -1.85 |
| Company 93 | 3.85 | 0.83 |
| Company 94 | 3.97 | 0.38 |
| Company 95 | 3.18 | -1.10 |
| Company 96 | 2.71 | 0.93 |
| Company 97 | 4.05 | 0.49 |
| Company 98 | 2.94 | -0.31 |
| Company 99 | 3.73 | -0.35 |
| Company 100 | 3.53 | -0.11 |
| Company 101 | 2.76 | 0.59 |
| Company 102 | 3.79 | 1.02 |
| Company 103 | 3.55 | 1.34 |
| Company 104 | 2.79 | 1.87 |
| Company 105 | 2.43 | -0.49 |
| Company 106 | 3.62 | 0.49 |
| Company 107 | 1.93 | 0.67 |
| Company 108 | 4.14 | -0.24 |
| Company 109 | 3.49 | -1.92 |
| Company 110 | 4.10 | -0.13 |
| Company 111 | 3.75 | 1.70 |
| Company 112 | 2.65 | -0.81 |
| Company 113 | 2.02 | 0.05 |
| Company 114 | 2.48 | -1.12 |
| Company 115 | 3.28 | -1.76 |
| Company 116 | 3.11 | -0.42 |
| Company 117 | 3.76 | -0.27 |
| Company 118 | 0.84 | -1.86 |
| Company 119 | 3.45 | 0.03 |
| Company 120 | 4.13 | 0.38 |
| Company 121 | 2.45 | -0.35 |
| Company 122 | 4.00 | -0.08 |
| Company 123 | 1.65 | -0.81 |
| Company 124 | 2.26 | 2.12 |
| Company 125 | 3.74 | 1.56 |
| Company 126 | 2.92 | -0.08 |
| Company 127 | 2.61 | -1.83 |
| Company 128 | 3.87 | -2.13 |
| Company 129 | 3.59 | 0.46 |
| Company 130 | 1.75 | -0.97 |
| Company 131 | 2.97 | 1.85 |
| Company 132 | 4.65 | -0.72 |
| Company 133 | 1.32 | -0.21 |
| Company 134 | 4.07 | -0.61 |
| Company 135 | 2.88 | -0.19 |
| Company 136 | 2.80 | 0.52 |
| Company 137 | 3.28 | 1.01 |
| Company 138 | 3.15 | 1.69 |
| Company 139 | 3.27 | 0.36 |
| Company 140 | 3.87 | -1.33 |
| Company 141 | 2.90 | 2.18 |
| Company 142 | 2.92 | 0.51 |
| Company 143 | 3.36 | 2.68 |
| Company 144 | 2.67 | -0.27 |
| Company 145 | 4.13 | -0.33 |
| Company 146 | 3.81 | 0.97 |
| Company 147 | 2.39 | 0.90 |
| Company 148 | 3.37 | 1.10 |
| Company 149 | 3.46 | 2.10 |
| Company 150 | 3.16 | 1.41 |
| Company 151 | 2.65 | 2.71 |
| Company 152 | 4.58 | -2.48 |
| Company 153 | 3.03 | -0.57 |
| Company 154 | 2.36 | -0.98 |
| Company 155 | 4.55 | -2.70 |
| Company 156 | 2.85 | -0.80 |
| Company 157 | 3.76 | 0.53 |
| Company 158 | 4.17 | -0.06 |
| Company 159 | 2.49 | -0.18 |
| Company 160 | 3.58 | -1.27 |
| Company 161 | 2.88 | 0.21 |
| Company 162 | 3.70 | 0.70 |
| Company 163 | 2.28 | 1.16 |
| Company 164 | 3.36 | 0.12 |
| Company 165 | 2.99 | 1.90 |
| Company 166 | 1.22 | -2.11 |
| Company 167 | 3.62 | 0.49 |
| Company 168 | 3.32 | 0.77 |
| Company 169 | 1.80 | 0.29 |
| Company 170 | 2.26 | -0.82 |
| Company 171 | 2.87 | 1.85 |
| Company 172 | 1.89 | 0.54 |
| Company 173 | 3.37 | 2.45 |
| Company 174 | 2.90 | -0.56 |
| Company 175 | 2.03 | 0.46 |
| Company 176 | 2.27 | -0.22 |
| Company 177 | 3.78 | 0.19 |
| Company 178 | 2.79 | -0.54 |
| Company 179 | 1.73 | -2.78 |
| Company 180 | 1.96 | -1.74 |
| Company 181 | 1.78 | -0.08 |
| Company 182 | 1.84 | -0.65 |
| Company 183 | 2.65 | 0.45 |
| Company 184 | 1.79 | -0.94 |
| Company 185 | 3.54 | 0.78 |
| Company 186 | 2.36 | -0.12 |
| Company 187 | 3.92 | -0.49 |
| Company 188 | 6.05 | -7.67 |
| Company 189 | 0.12 | 5.32 |
| Company 190 | 6.21 | -6.54 |
| Company 191 | 0.23 | 5.12 |
Solutions
orchestra answered 2 years agoRelated Solutions
Please finish the following assignments in Excel and submit the Excel file onto Pilot. Please use...
Please finish the following assignments in Excel and submit the
Excel file onto Pilot.
Please use the data in “GPS.XSLS” to:
Q1. Estimate the parameter p and q in Bass Model.
Q2. Compute the time and value of peak sales.
Year
Sales (00s)
1990
164
1991
276
1992
578
1993
1604
1994
3435
1995
5785
1996
8500
1997
12000
1998
15000
1999
18000
2000
20000
Please show the steps thank you
Discussion How to use Excel to compute the descriptive statistics and/or calculate probabilities for a Normal/Binomial...
Discussion
How to use Excel to compute the descriptive statistics and/or
calculate probabilities for a Normal/Binomial distribution?
Please finish the following assignment in Excel Does price affect sales? Does Advertising affect sales? Are...
Please finish the following assignment in
Excel
Does price affect sales?
Does Advertising affect sales?
Are there any interaction effects between price and
advertising? Show it with graph.
Price
Low
Medium
High
Low
41
21
15
Adv
25
20
14
23
16
13
Medium
28
28
14
30
22
13
32
18
12
High
50
34
13
51
40
13
52
32
13
please answer using excel and explain What are the appropriate descriptive statistics to summarize the Company-Z...
please answer using excel and explain
What are the appropriate descriptive statistics to
summarize the Company-Z daily sales in Pre- and Post-
COVID-19 Y1 &
Y2? Can you visualize both
random variables separately using the graphing technique?
Explain why you used these descriptive statistics and this graphing
technique?
Given;
Date
Pre-COVID-19
Date
Post-COVID-19
Y1
X1
Y2
X2
1-Nov-2019
4365.5
7.0
1-Apr-2020
3612.2
11.9
2-Nov-2019
4365.8
7.1
2-Apr-2020
3617.0
8.6
3-Nov-2019
4366.3
7.2
3-Apr-2020
3614.9
7.9
4-Nov-2019
4365.9
7.7
4-Apr-2020...
Please finish the following assignment in Excel. Ignoring price, create a chart that displays the seasonality...
Please finish the following assignment in Excel.
Ignoring price, create a chart that displays the seasonality of
cranberry sales.
Ignoring price, create a chart that shows whether there is an
upward trend in sales.
Determine average sales per quarter, breaking it down based on
whether your price was higher or lower than the competitor’s price.
You can use the following function to transform the price into a
category variable: “=IF(J14<K14,"Higher Price",
"Lower Price")”
Year
Quarter
Units
Competitor Price
My Price
2006...
Use Descriptive Statistics in Excel to find the mean, median, range and standard deviation of the...
Use Descriptive Statistics in Excel to find the mean, median,
range and standard deviation of the data below.
Table 1: Health Expenditures as a
Percentage of GDP of countries around the world
3.35
5.96
10.64
5.24
3.79
5.65
7.66
7.38
5.87
11.15
5.96
4.78
7.75
2.72
9.50
7.69
10.05
11.96
8.18
6.74
5.89
6.20
5.98
8.83
6.78
6.66
9.45
5.41
5.16
8.55
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to...
Case 1 Instruction (Accounting Application) Use the MS Excel
tabular graphical methods of descriptive statistics to summarize
the sample data in the data set named PelicanStores in Case 1
folder. The managerial report should contain summaries such as:
1. A frequency and relative frequency distributions for the
methods of payment (different cards). (20%)
2. Mean, median, first quartile, third quartile, and sample
standard deviation for net sales from regular customers. (20%)
3. Mean, median, first quartile, third quartile, and sample...
Case 1 Instruction (Accounting Application) Use the MS Excel tabular graphical methods of descriptive statistics to...
Case 1 Instruction (Accounting Application) Use the MS Excel
tabular graphical methods of descriptive statistics to summarize
the sample data in the data set named PelicanStores in Case 1
folder. The managerial report should contain summaries such as:
1. A frequency and relative frequency distributions for the
methods of payment (different cards). (20%)
2. Mean, median, first quartile, third quartile, and sample
standard deviation for net sales from regular customers. (20%)
3. Mean, median, first quartile, third quartile, and sample...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet,
Thank you so much!
The following are the runs scored totals for 9 players for the
2016 New York Yankees: 56,43,63,68,58,80,71,32,19
(a) Find the mean and median
(b) Find the standard deviation of this population
(c) Considering this as a normal sample of American League
players for the 2016 season, find a 99% Confidence Interval for the
actual mean of Runs Scored for AL players, 2016 .
(d) Considering...
Thinking about the research you've been writing about for your assignments, which descriptive statistics do you...
Thinking about the research you've been writing about for your
assignments, which descriptive statistics do you feel would be most
important for you to report if you were to collect and analyze
data? Why? How would you visually present this data to your reader?
Please be specific.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Rotating bits in C This rotates bits to the left which means the bits that were...
- Implement a method that meets the following requirements: (a) Takes as parameter 1) an int array...
- Write a function that takes a binary search tree as input and produces a linked list...
- XYZ Company is considering purchasing a piece of equipment costing $400,000. It has a useful life...
- Reflection of the short film "How Wolves Change Rivers" and Aldo Leopold's "Thinking Like A Mountain".
- What kind of rebar would be most cost effective for foundation? Would it be to design...
- Why would UnderArmour want to be sure that consumers can clearly see different models ( about...
ADVERTISEMENT