This is an assignment in my business statistics class (FINA 220)This assignment consists of solving 4 problems from the textbook (Statistical Techniques in Business and Economics, 16 th Edition, McGraw-Hill), two from chapter 2 and two from chapter 3. Excel data files are provided below for each of the problem. When you solve the 4 problems, please copy the data into 4 tabs of one Worksheet before you start. Do not keep it in 4 files.Here are the problems:2.30) The weekly amounts spent on groceries for a sample of 45 households is provided in the attached file. a) How many classes would you recommend for grouping the data?b) What class interval would you suggest?c) What would you recommend as the lower limit of the first class?d) Organize the data into a frequency distribution.e) Plot the distribution using a bar chart in Excel.2.43) Merill Lynch recently completed a study regarding the size of online investment portfolios (stocks, bonds, mutual funds, and certificates of deposit) for a sample of clients in the 40 up to 50 years old age group. The value of all investments in thousands of dollars for the 70 participants in the study is provided in the attached file.a) Organize the data into frequency distribution. How many classes would you suggest ? What value would you suggest for a class interval?b) Draw a histogram. Inerpret your results.c) What is the mean, the variance, and the standard deviation of the data?3.65 A sample of households that subscribe to United Bell Company for landline phone service revealed the following number of calls received per household last week (see attached data file for the numbers). Determine the mean and the median number of calls received.3.77 The enrollments of the 13 public universities in Ohio is given in the attached data file.a) Is this a sample or a population?b) What is the mean enrollment?c) What is the median enrollment?d) What is the range of enrollments?e) Compute the standard deviation.

Module 02 Written Assignment - Probability II & Financial Math Click on the link below for this module's problems. Module 02 Written Assignment    Make  sure you following all instructions given in the document. All steps  and explanations (when asked) are required for full credit!

Question 1 (5 points) Find the circumference of the circle. Round to the nearest tenth. Question 1 options: Question 2 (5 points) Find the area of the circle. Round to the nearest tenth. diameter = 8 ydQuestion 2 options: 12.6 yd2 25.1 yd2 50.3 yd2 201.1 yd2 Question 3 (5 points) Find the volume of the solid shown or described. If necessary, round to the nearest tenth. Question 3 options: Question 4 (5 points) Find the surface area of the solid shown or described. If necessary, round to the nearest tenth. Question 4 options: Question 5 (5 points) Find the area of a circle having a circumference of 23? units. Round to the nearest tenth. Question 5 options: 355 units2 415.5 units2 831 units2 462.3 units2 Question 6 (5 points) Find the volume of the solid shown or described. If necessary, round to the nearest tenth. Find the volume of the figure below. Round to the nearest tenth. Question 6 options: 2339.2 cm3 2595.8 cm3 3057.6 cm3 3822 cm3 Question 7 (5 points) Find the volume of the solid shown or described. If necessary, round to the nearest tenth. Question 7 options: Question 8 (5 points) Find the area of the circle. Round to the nearest tenth. Question 8 options: Question 9 (5 points) Find the lateral area of the prism. Use the 10 by 6 rectangle as the base. Question 9 options: 258 198 270 150 Question 10 (5 points) What is the area of a figure that is formed using a parallelogram with base 5.2 meters and height 3 meters, and a semicircle with a radius of 4 meters. Round to the nearest tenth, if necessary. Question 10 options: 40.7 m2 40.733 m2 33.3 m2 28.2 m2 Question 11 (5 points) Find the circumference of the circle. Round to the nearest tenth. Question 11 options: Question 12 (5 points) Find the volume of the solid shown or described. If necessary, round to the nearest tenth. Question 12 options: Question 13 (5 points) Describe the shape resulting from a vertical cross section of the figure. Question 13 options: rectangle square trapezoid triangle Question 14 (5 points) Find the area of the figure to the nearest tenth, if necessary. Question 14 options: Question 15 (5 points) Find the lateral area and surface area of the solid. Use the 2.5 by 2.5 square as the base. Round to the nearest tenth if necessary. Question 15 options: L = 220 ; S = 302.5 L = 280.5 ; S = 220 L = 170.5 ; S = 280.5 L = 220 ; S = 280.5 Question 16 (5 points) Find the volume of the solid shown or described. If necessary, round to the nearest tenth. Denise used a cube and a rectangular prism to make a trophy stand with the dimensions shown. What is the volume of the figure? Question 16 options: 786.2 in.3 661.2 in.3 613.2 in.3 951.3 in.3 Question 17 (5 points) Find the volume of the solid shown or described. If necessary, round to the nearest tenth. What is the volume of the shed? Question 17 options: 46 m3 38 m3 42 m3 27.7 m3  Question 18 (5 points) A window is shaped like a semicircle with a diameter of 5.2 feet. What is the area of the window? Round to the nearest tenth.   Question 18 options: 21.2 ft2 42.5 ft2 7.6 ft2 10.6 ft2 Question 19 (5 points) The circumference of a pizza is about 38 inches. What is the diameter of the pizza? Round to the nearest tenth if necessary.   Question 19 options: 6 in. 12.1 in. 12.7 in. 24.2 in. Question 20 (5 points) Find the shape resulting from the cross section of the cylinder. Question 20 options: triangle square circle rectangle Submit Quiz0 of 20 questions saved