Business Analytics
3rd Edition
ISBN: 9780135231678
Author: Evans, James R. (james Robert)
Publisher: PEARSON EDUCATION (COLLEGE)
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 3, Problem 2.4PE
To determine
Delineate the way to construct a Pivot Table for the Credit Risk database and also show the number of loans by different purposes, marital status, and credit risk.
Elucidate the results in a pivot chart.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Given the sample space:
ΩΞ
= {a,b,c,d,e,f}
and events:
{a,b,e,f}
A = {a, b, c, d}, B = {c, d, e, f}, and C = {a, b, e, f}
For parts a-c: determine the outcomes in each of the provided sets. Use proper set
notation.
a.
(ACB)
C
(AN (BUC) C) U (AN (BUC))
AC UBC UCC
b.
C.
d.
If the outcomes in 2 are equally likely, calculate P(AN BNC).
Suppose a sample of O-rings was obtained and the wall thickness (in inches) of each
was recorded. Use a normal probability plot to assess whether the sample data could
have come from a population that is normally distributed.
Click here to view the table of critical values for normal probability plots.
Click here to view page 1 of the standard normal distribution table.
Click here to view page 2 of the standard normal distribution table.
0.191 0.186 0.201 0.2005
0.203 0.210 0.234 0.248
0.260 0.273 0.281 0.290
0.305 0.310 0.308 0.311
Using the correlation coefficient of the normal probability plot, is it reasonable to conclude that the population is
normally distributed? Select the correct choice below and fill in the answer boxes within your choice.
(Round to three decimal places as needed.)
○ A. Yes. The correlation between the expected z-scores and the observed data, , exceeds the critical value,
. Therefore, it is reasonable to conclude that the data come from a normal population.
○…
ding question
ypothesis at a=0.01 and at a =
37. Consider the following hypotheses:
20
Ho: μ=12
HA: μ12
Find the p-value for this hypothesis test based on the following
sample information.
a. x=11; s= 3.2; n = 36
b. x = 13; s=3.2; n = 36
C.
c.
d.
x = 11; s= 2.8; n=36
x = 11; s= 2.8; n = 49
Chapter 3 Solutions
Business Analytics
Ch. 3 - Explain the pros and cons of tabular versus visual...Ch. 3 - How is data visualization used in descriptive,...Ch. 3 - Summarize the most useful charts available in...Ch. 3 - Prob. 2.2CYUCh. 3 - Prob. 2.3CYUCh. 3 - Prob. 2.4CYUCh. 3 - Prob. 3.1CYUCh. 3 - What is a heatmap, and what are some typical...Ch. 3 - Prob. 3.3CYUCh. 3 - Prob. 4.1CYU
Ch. 3 - Prob. 4.2CYUCh. 3 - Prob. 4.3CYUCh. 3 - Create clustered column and stacked column charts...Ch. 3 - Prob. 1.2PECh. 3 - Prob. 1.3PECh. 3 - Prob. 1.4PECh. 3 - Prob. 1.5PECh. 3 - Prob. 1.6PECh. 3 - Prob. 1.7PECh. 3 - Prob. 1.8PECh. 3 - Construct a column chart for the data in the Excel...Ch. 3 - The Excel file Internet Usage provides data about...Ch. 3 - Construct an appropriate chart to show the...Ch. 3 - Construct an appropriate chart or charts to...Ch. 3 - Prob. 1.13PECh. 3 - In the Excel file Banking Data, apply the...Ch. 3 - Prob. 1.15PECh. 3 - Prob. 1.16PECh. 3 - Prob. 1.17PECh. 3 - Prob. 1.18PECh. 3 - Create a useful dashboard for the data in the...Ch. 3 - Prob. 1.20PECh. 3 - Prob. 1.21PECh. 3 - Prob. 2.1PECh. 3 - Prob. 2.2PECh. 3 - Prob. 2.3PECh. 3 - Prob. 2.4PECh. 3 - Use PivotCharts to create a useful dashboard for...Ch. 3 - Prob. 2.6PECh. 3 - Prob. 2.7PECh. 3 - Prob. 2.8PECh. 3 - Use PivotCharts to create a useful dashboard for...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- 13. A pharmaceutical company has developed a new drug for depression. There is a concern, however, that the drug also raises the blood pressure of its users. A researcher wants to conduct a test to validate this claim. Would the manager of the pharmaceutical company be more concerned about a Type I error or a Type II error? Explain.arrow_forwardFind the z score that corresponds to the given area 30% below z.arrow_forwardFind the following probability P(z<-.24)arrow_forward
- 3. Explain why the following statements are not correct. a. "With my methodological approach, I can reduce the Type I error with the given sample information without changing the Type II error." b. "I have already decided how much of the Type I error I am going to allow. A bigger sample will not change either the Type I or Type II error." C. "I can reduce the Type II error by making it difficult to reject the null hypothesis." d. "By making it easy to reject the null hypothesis, I am reducing the Type I error."arrow_forwardGiven the following sample data values: 7, 12, 15, 9, 15, 13, 12, 10, 18,12 Find the following: a) Σ x= b) x² = c) x = n d) Median = e) Midrange x = (Enter a whole number) (Enter a whole number) (use one decimal place accuracy) (use one decimal place accuracy) (use one decimal place accuracy) f) the range= g) the variance, s² (Enter a whole number) f) Standard Deviation, s = (use one decimal place accuracy) Use the formula s² ·Σx² -(x)² n(n-1) nΣ x²-(x)² 2 Use the formula s = n(n-1) (use one decimal place accuracy)arrow_forwardTable of hours of television watched per week: 11 15 24 34 36 22 20 30 12 32 24 36 42 36 42 26 37 39 48 35 26 29 27 81276 40 54 47 KARKE 31 35 42 75 35 46 36 42 65 28 54 65 28 23 28 23669 34 43 35 36 16 19 19 28212 Using the data above, construct a frequency table according the following classes: Number of Hours Frequency Relative Frequency 10-19 20-29 |30-39 40-49 50-59 60-69 70-79 80-89 From the frequency table above, find a) the lower class limits b) the upper class limits c) the class width d) the class boundaries Statistics 300 Frequency Tables and Pictures of Data, page 2 Using your frequency table, construct a frequency and a relative frequency histogram labeling both axes.arrow_forward
- Table of hours of television watched per week: 11 15 24 34 36 22 20 30 12 32 24 36 42 36 42 26 37 39 48 35 26 29 27 81276 40 54 47 KARKE 31 35 42 75 35 46 36 42 65 28 54 65 28 23 28 23669 34 43 35 36 16 19 19 28212 Using the data above, construct a frequency table according the following classes: Number of Hours Frequency Relative Frequency 10-19 20-29 |30-39 40-49 50-59 60-69 70-79 80-89 From the frequency table above, find a) the lower class limits b) the upper class limits c) the class width d) the class boundaries Statistics 300 Frequency Tables and Pictures of Data, page 2 Using your frequency table, construct a frequency and a relative frequency histogram labeling both axes.arrow_forwardA study was undertaken to compare respiratory responses of hypnotized and unhypnotized subjects. The following data represent total ventilation measured in liters of air per minute per square meter of body area for two independent (and randomly chosen) samples. Analyze these data using the appropriate non-parametric hypothesis test. Unhypnotized: 5.0 5.3 5.3 5.4 5.9 6.2 6.6 6.7 Hypnotized: 5.8 5.9 6.2 6.6 6.7 6.1 7.3 7.4arrow_forwardThe class will include a data exercise where students will be introduced to publicly available data sources. Students will gain experience in manipulating data from the web and applying it to understanding the economic and demographic conditions of regions in the U.S. Regions and topics of focus will be determined (by the student with instructor approval) prior to April. What data exercise can I do to fulfill this requirement? Please explain.arrow_forward
- Consider the ceocomp dataset of compensation information for the CEO’s of 100 U.S. companies. We wish to fit aregression model to assess the relationship between CEO compensation in thousands of dollars (includes salary andbonus, but not stock gains) and the following variates:AGE: The CEOs age, in yearsEDUCATN: The CEO’s education level (1 = no college degree; 2 = college/undergrad. degree; 3 = grad. degree)BACKGRD: Background type(1= banking/financial; 2 = sales/marketing; 3 = technical; 4 = legal; 5 = other)TENURE: Number of years employed by the firmEXPER: Number of years as the firm CEOSALES: Sales revenues, in millions of dollarsVAL: Market value of the CEO's stock, in natural logarithm unitsPCNTOWN: Percentage of firm's market value owned by the CEOPROF: Profits of the firm, before taxes, in millions of dollars1) Create a scatterplot matrix for this dataset. Briefly comment on the observed relationships between compensationand the other variates.Note that companies with negative…arrow_forward6 (Model Selection, Estimation and Prediction of GARCH) Consider the daily returns rt of General Electric Company stock (ticker: "GE") from "2021-01-01" to "2024-03-31", comprising a total of 813 daily returns. Using the "fGarch" package of R, outputs of fitting three GARCH models to the returns are given at the end of this question. Model 1 ARCH (1) with standard normal innovations; Model 2 Model 3 GARCH (1, 1) with Student-t innovations; GARCH (2, 2) with Student-t innovations; Based on the outputs, answer the following questions. (a) What can be inferred from the Standardized Residual Tests conducted on Model 1? (b) Which model do you recommend for prediction between Model 2 and Model 3? Why? (c) Write down the fitted model for the model that you recommended in Part (b). (d) Using the model recommended in Part (b), predict the conditional volatility in the next trading day, specifically trading day 814.arrow_forward4 (MLE of ARCH) Suppose rt follows ARCH(2) with E(rt) = 0, rt = ut, ut = στει, σε where {+} is a sequence of independent and identically distributed (iid) standard normal random variables. With observations r₁,...,, write down the log-likelihood function for the model esti- mation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Introduction to Integers,Maths - What are integers - English; Author: Mathispower4u;https://www.youtube.com/watch?v=04pURxo-iu0;License: Standard YouTube License, CC-BY
Integers-Middle School Math; Author: MooMooMath and Science;https://www.youtube.com/watch?v=DGWcWtqM_yk;License: Standard YouTube License, CC-BY