Identify each of the variables in the Excel file Credit Approval Decisions as categorical, ordinal, interval, or ratio and explain why.

4.3. Identify each of the variables in the Excel file Credit Approval Decisions as categorical, ordinal, interval, or ratio and explain why. (6pts)
4.6. Use the COUNTIF function to construct a frequency distribution of the types of loans in the Excel file Credit Risk Data, develop a column chart to express the results visually, and compute the relative frequencies. (4pts)
4.9. Use the Histogram tool to construct frequency distributions and histograms for weekly usage and wait-ing time in the Excel file Car Sharing Survey. (6pts)
4.13. Use a PivotTable to construct a frequency distribution and histogram of lunch sales amounts in the Restaurant Sales database. (4pts)
4.16. Find the 20th and 80th percentiles of home prices in the Excel file Home Market Value. Use formula (4.3), the Excel PERCENTILE.INC function, and the Rank and Percentile tool, and compare the results. (6pts)
4.20. Use a PivotTable to construct a cross-tabulation for loan purpose and credit risk for the Base Data worksheet in the Excel file Credit Risk Data. (3pts)
4.24. Find the mean, median, and midrange for the data in the Excel file Automobile Quality using the appropriate Excel functions or formulas. (3pts)
4.28. Considering the data in the Excel file Home Market Value as a sample of homeowners on this street, compute the mean, variance, and standard deviation for each of the variables using formulas (4.5), (4.8), and (4.10). Verify your calculations using the appropriate Excel function. (10pts)
4.29. In the Excel file Facebook Survey, find the range, variance, standard deviation, and interquartile range for hours online/week and the number of friends in the sample using the appropriate Excel functions. Compare these measures of dispersion. (9pts)
4.32. The Excel file Atlanta Airline Data provides arrival and taxi-in time statistics for one day at Atlanta Hartsfield International Airport. Find the mean and standard deviation of the difference between the scheduled and actual arrival times and the taxi-in time to the gate. Compute the z-scores for each of these variables. (6pts)
4.34. Compute the coefficient of variation for each variable in the Excel file Home Market Value. Identify Which has the least and greatest relative dispersion? (14pts)
4.37. Use the Descriptive Statistics tool to summarize the percent gross profit, gross sales, and gross profit in the Excel file Sales Data. (4pts)
4.46. In the Excel file Bicycle Inventory, find the proportion of bicycle models that sell for less than $200. (3pts)
4.55. Using PivotTables, find the mean and standard deviation of sales by region in the Sales Transactions database. (3pts)
4.62. The Excel file Beverage Sales lists a sample of week-day sales at a convenience store, along with the daily high temperature. Compute the covariance and correlation between temperature and sales. (2pts)
4.66. Compute the z-scores for the data in the Excel file Airport Service Times. How many observations fall farther than three standard deviations from either side of the mean? Would you consider these as outliers? Why or why not? (5pts)
The post Identify each of the variables in the Excel file Credit Approval Decisions as categorical, ordinal, interval, or ratio and explain why. ACADEMIC ASSISTERS. ACADEMIC ASSISTERS.

>>>Click here to get this paper written at the best price. 100% Custom, 0% plagiarism.<<<

The post Identify each of the variables in the Excel file Credit Approval Decisions as categorical, ordinal, interval, or ratio and explain why. appeared first on First Class Essay Writers.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *