![Essentials of Business Analytics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305627734/9781305627734_largeCoverImage.gif)
Concept explainers
1.
Obtain the
1.
![Check Mark](/static/check-mark.png)
Answer to Problem 1C
Descriptive statistics for the data is as follows:
Explanation of Solution
Calculation:
The given information is about a young professional magazine. The magazine was successful in two years of publication. The magazine wants to expand the advertising base. The potential advertiser continually asks about the demographics and the interests of the subscribers to young professionals. The magazine conducts a survey to develop subscribers.
Software Procedure:
Step by step procedure to obtain the descriptive statistics using the Excel software:
- Enter the data in Excel spread sheet.
- Choose Data > Data Analysis > Descriptive Statistics.
- In Input
range , select the columns of Age, Investment, Transactions, and Household income. - Select Labels in first row check box and then select the output range.
- Select Summary statistics check box and confidence interval for
Mean check box. - Click OK.
Output using the Excel software is given below:
2.
Find the 95% confidence interval for the mean age and household income of subscribers.
2.
![Check Mark](/static/check-mark.png)
Answer to Problem 1C
There is 95% confidence that the mean of the young professional subscribers of the age between 29.722 and 30.503 and there is 95% confidence that the mean of the young professional subscribers of the household income between $71,079 and $77,840.
Explanation of Solution
From the part (a) output, Mean and Margin of error for Age is 30.1122 and 0.3907. The mean and margin error for Household is 74459.51 and 3380.257.
The 95% confidence interval for the mean age is calculated as follows:
The 95% confidence interval for the mean household is calculated as follows:
Thus, there is 95% confidence that the mean of the young professional subscribers of the age between 29.722 and 30.503. There is 95% confidence that the mean of the young professional subscribers of the household income between $71,079 and $77,840.
3.
Find the 95% confidence interval for the proportion of the subscribers who have the broadband access at home and the proportion of the subscribers who have children.
3.
![Check Mark](/static/check-mark.png)
Answer to Problem 1C
There is 95% confidence that the proportion of the young professional subscribers who have the broadband access between 57.75% and 67.14%.
There is 95% confidence that the proportion of the young professional subscribers who have children between 48.45% and 58.33%.
Explanation of Solution
The proportion of the young professional subscribers who have the broadband access:
Here 256 have access out of 410 subscribers.
Thus, the point estimate
The proportion of the young professional subscribers who have children
Here 219 have children out of 410 subscribers.
Thus, the point estimate
Here, the level of significance is 0.05.
The level of significance or probability for two-tailed is given as
The critical value is calculated by using the excel formula “=NORM.S.INV (probability)”.
Substitute the values in the excel formula: “=NORM.S.INV (0.025)”.
Thus the critical value is obtained as 1.96.
The 95% confidence that the proportion of the young professional subscribers who have the broadband access is given as:
There is 95% confidence that the proportion of the young professional subscribers who have the broadband access between 57.75% and 67.14%.
The 95% confidence 95% confidence that the proportion of the young professional subscribers who have children is given as:
There is 95% confidence that the proportion of the young professional subscribers who have children between 48.45% and 58.33%.
4.
Illustrate whether the young professionals are a good advertising outlet for online brokers or not. Justify with the statistical conclusion.
4.
![Check Mark](/static/check-mark.png)
Answer to Problem 1C
The young professionals are the good advertising outlet for online brokers.
Explanation of Solution
From the results of Part 1, Most of the young professional subscribers have the financial investment for their home as $28,538. Some of them have the amount of investment like more than $100,000. So the mean number of transactions per year is nearly 6 per subscriber and some of the subscribers have mean number of transactions more than 6.
Since the large proportion has the broadband access that is 62.43%. It indicates that most of their subscribers likely to do business.
Thus, young professionals are the good advertising outlet for online brokers.
5.
Illustrate whether the magazine is good place for advertising companies, selling educational software, and computer games for young children.
5.
![Check Mark](/static/check-mark.png)
Explanation of Solution
From the results of Part 1,
The mean age of subscribers is 30.112 years and 53.41% of the subscribers have children. The age of subscribers is reasonable to assume that their children are young age and then they can think that the young age children like about the educational software and the computer games.
Thus, it represents that the subscribers to young professional would be a good target for companies selling educational software and computer games for young children.
6.
Illustrate the types of articles that would be interested to readers of young professionals.
6.
![Check Mark](/static/check-mark.png)
Explanation of Solution
By observing the results in Part 1, most of the young professionals are interested on the investment and for that the investment type of articles may be interested to the professionals. Also, the subscribers who have young children will be interested to read the parenting and child care types of articles.
Want to see more full solutions like this?
Chapter 6 Solutions
Essentials of Business Analytics (MindTap Course List)
- Examine the Variables: Carefully review and note the names of all variables in the dataset. Examples of these variables include: Mileage (mpg) Number of Cylinders (cyl) Displacement (disp) Horsepower (hp) Research: Google to understand these variables. Statistical Analysis: Select mpg variable, and perform the following statistical tests. Once you are done with these tests using mpg variable, repeat the same with hp Mean Median First Quartile (Q1) Second Quartile (Q2) Third Quartile (Q3) Fourth Quartile (Q4) 10th Percentile 70th Percentile Skewness Kurtosis Document Your Results: In RStudio: Before running each statistical test, provide a heading in the format shown at the bottom. “# Mean of mileage – Your name’s command” In Microsoft Word: Once you've completed all tests, take a screenshot of your results in RStudio and paste it into a Microsoft Word document. Make sure that snapshots are very clear. You will need multiple snapshots. Also transfer these results to the…arrow_forward2 (VaR and ES) Suppose X1 are independent. Prove that ~ Unif[-0.5, 0.5] and X2 VaRa (X1X2) < VaRa(X1) + VaRa (X2). ~ Unif[-0.5, 0.5]arrow_forward8 (Correlation and Diversification) Assume we have two stocks, A and B, show that a particular combination of the two stocks produce a risk-free portfolio when the correlation between the return of A and B is -1.arrow_forward
- 9 (Portfolio allocation) Suppose R₁ and R2 are returns of 2 assets and with expected return and variance respectively r₁ and 72 and variance-covariance σ2, 0%½ and σ12. Find −∞ ≤ w ≤ ∞ such that the portfolio wR₁ + (1 - w) R₂ has the smallest risk.arrow_forward7 (Multivariate random variable) Suppose X, €1, €2, €3 are IID N(0, 1) and Y2 Y₁ = 0.2 0.8X + €1, Y₂ = 0.3 +0.7X+ €2, Y3 = 0.2 + 0.9X + €3. = (In models like this, X is called the common factors of Y₁, Y₂, Y3.) Y = (Y1, Y2, Y3). (a) Find E(Y) and cov(Y). (b) What can you observe from cov(Y). Writearrow_forward1 (VaR and ES) Suppose X ~ f(x) with 1+x, if 0> x > −1 f(x) = 1−x if 1 x > 0 Find VaRo.05 (X) and ES0.05 (X).arrow_forward
- Joy is making Christmas gifts. She has 6 1/12 feet of yarn and will need 4 1/4 to complete our project. How much yarn will she have left over compute this solution in two different ways arrow_forwardSolve for X. Explain each step. 2^2x • 2^-4=8arrow_forwardOne hundred people were surveyed, and one question pertained to their educational background. The results of this question and their genders are given in the following table. Female (F) Male (F′) Total College degree (D) 30 20 50 No college degree (D′) 30 20 50 Total 60 40 100 If a person is selected at random from those surveyed, find the probability of each of the following events.1. The person is female or has a college degree. Answer: equation editor Equation Editor 2. The person is male or does not have a college degree. Answer: equation editor Equation Editor 3. The person is female or does not have a college degree.arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781938168994/9781938168994_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337111348/9781337111348_smallCoverImage.gif)