Questions from Analytics

Q: In the Excel file Weddings, determine the correlation between the

In the Excel file Weddings, determine the correlation between the wedding costs and attendance

Q: Describe how to apply stratified sampling to sample from the

Describe how to apply stratified sampling to sample from the Credit Risk Data file based on the different types of loans. Implement your process in Excel to choose a random sample consisting of 10% of...

Q: For the data in the Excel file Rin’s Gym, find

For the data in the Excel file Rin’s Gym, find the co-variances and correlations among height, weight, and BMI calculation

Q: For the President’s Inn Guest Database file, find the average

For the President’s Inn Guest Database file, find the average length of stay and number of guests. Is there any correlation between the size of the party and the length of stay?

Q: The Excel file Beverage Sales lists a sample of weekday

The Excel file Beverage Sales lists a sample of weekday sales at a convenience store, along with the daily high temperature. Compute the covariance and correlation between temperature and sales

Q: Using the data in the Excel file Student Grades, apply

Using the data in the Excel file Student Grades, apply the Excel Regression tool using the midterm grade as the independent variable and the final exam grade as the dependent variable.a. Interpret all...

Q: The actual delivery time from Giodanni’s Pizza is exponentially distributed

The actual delivery time from Giodanni’s Pizza is exponentially distributed with a mean of 20 minutes.a. What is the probability that the delivery time will exceed 30 minutes?b. What proportion of del...

Q: Example 1.4 in Chapter 1 described a scenario for new

Example 1.4 in Chapter 1 described a scenario for new product sales that can be characterized by a formula called a Gompertz curve: S = aebect. Develop a spreadsheet for calculating sales using this f...

Q: For the Excel file Credit Risk Data, compute the correlation

For the Excel file Credit Risk Data, compute the correlation between age and months employed, age and combined checking and savings account balance, and the number of months as a customer and amount o...

Q: In the Excel file Call Center Data, how strongly is

In the Excel file Call Center Data, how strongly is length of service correlated with starting age?