Question

In: Math

Answer the following application exercise on organization and visualization of data. 1. You can use Excel....

Answer the following application exercise on organization and visualization of data.
1. You can use Excel.
2. If you use the calculator and perform the exercise manually, obtain a photo of the process performed using the clipping and search of your result in Word.
3. Remember to include presentation sheet in APA format.
A sample of 30 employees who work investigating cases of possible money laundering, answers a survey about the average time in days we take them analyzes, present findings and recommendations. Next, your answers are detailed
25 22 20 16 13 16 32 26 13 24 15 15 14 14 54 11 24 24 24 19 17 10 16 48 11 13 20 13 12 24
Summary of this data:
1. Building a frequency distribution table.
2. Building graphical representations: histogram, frequency polygon and warhead.
3. Calculating the measures of central tendency: mean, mode and median.
4. Make a comment on what the data related to the average time of days to solve each case indicate.

Solutions

Expert Solution

(1). Frequency distribution table: Frequency tells you how often of times something happened.

(2).

Histogram:- A histogram is a graphical display of data using bars of different heights.

Frequency polygon:- A frequency polygon is a graph constructed by using lines to join the midpoints of each interval or bin.

(3).

mean = 19.73

mode = 24

median = 16.5

(4). The data related to the average time of days to solve each case indicates the average(mean, mode, median) can help in solving the investigating cases of possible money laundering.


Related Solutions

Answer the following application exercise on organization and data visualization. You can use Excel. If you...
Answer the following application exercise on organization and data visualization. You can use Excel. If you use the calculator and perform the exercise manually, obtain a picture of the process performed using the cutout and pasting its result into a Word file. A sample of 30 employees who investigate cases of possible money laundering, answered a survey on the average time in the days analyzed, presented results and recommendations. Below, your answers are detailed. 5 22 20 16 13 6...
Exercise 1 Construct an amortization table in Excel to answer the following questions. You must use...
Exercise 1 Construct an amortization table in Excel to answer the following questions. You must use the corresponding Excel financial formulas whenever possible. Upon graduation, Federico Hernández, borrows $20,000 to finance a late model used car. The loan is made by a family member who was able to obtain an 8 % annual percent rate (APR). The loan is going to be payback in equal monthly payments over 5 years. a) How much are the monthly payments? b) How many...
Data Visualization questions; 1. Please discuss briefly (50 words) tow datincts applications where data visualization can...
Data Visualization questions; 1. Please discuss briefly (50 words) tow datincts applications where data visualization can be used. 2. In about 50 words each, please comment on three distinct aspects of data visualization about which you learned in this topic. Linear Regression Questions; in 50 words each, discuss three distinct applications where linear regression could be used effectively. explain why each application is a good candidate for profuctive use of linear regression tools.
Conduct an analysis (you can use Excel) to answer the following question. Show an ANOVA table....
Conduct an analysis (you can use Excel) to answer the following question. Show an ANOVA table. A grower wishes to compare yields of four different varieties of pumpkins for yield (tons/ac).  His experiment consisted of four replications for each variety.  Is there a significant difference between the varieties in yield?  Do a Tukey’s test. Give complete conclusions with a properly labeled tabulated results. Data are as follows: Variety A        Variety B        Variety C       Variety D 27                   29                   30                   32 28                   28                   29                   29 29                   29                   29                   31 25                   27                   31                   32 An experiment was conducted to compare the...
To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be...
To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be using linear programming and Solver in Excel to solve the problem described in the following scenario. At Goodman Shipping, the load master wants to determine the mix of cargo to be carried on the next trip. The ship's volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons. The master has five different types of cargo from which to...
what is data visualization and why it matters in the future? can you explain the importance...
what is data visualization and why it matters in the future? can you explain the importance of data visualization and some examples? data visualization for human perception and benefits.
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...
Use the data for two Sydney suburbs to answer questions 1-5:             1     Using Excel or other...
Use the data for two Sydney suburbs to answer questions 1-5:             1     Using Excel or other appropriate software, produce two separate histograms for the median rental prices of the two selected suburbs, respectively.            Use an appropriate number of bins for your histogram and remember to label the axes. Describe and compare the two histograms, including the central location, dispersion and skewness. [1 mark]                   2     Compute the sample means and sample standard deviations of the median rental prices...
Exercise 1: Assume you have the following data about a country. Use the information and formulas...
Exercise 1: Assume you have the following data about a country. Use the information and formulas in chapter 9 and the chapter 9 study guide to fill in the table below. (Note: these are actual data, except the rate of economic growth. Rate of economic growth data are roughly US’s average from the past (3%) and China’s projected growth rate in the near future. Are these good assumptions to use?) USA China Nominal GDP 2019 (in millions of US$) 21,430,000...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel,...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel, include the appropriate output (copy + paste) along with an explanation. Data description: An article in The Wall Street Journal (July 11, 2008) outlined a number of reasons as to why the 16 teams in Major League Baseball’s National League (NL) are inferior to the 14 teams in the American League (AL). One reason for the imbalance pointed to the disparity in opening-day payrolls:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT