Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Exercise: 1. Use the questioner paper to collect 35 different data. For every question, you can check the screenshot to see how your answer should
Exercise: 1. Use the questioner paper to collect 35 different data. For every question, you can check the screenshot to see how your answer should look, but do not use the same names and values. 2. Create a new Excel Workbook and fill in the data in sheetl and rename it "Customer Data". Monthly Monthly Monthly Megabytes phone bill internet cost income spent 125 Mobile Age Gender operator system 301F ANDROID 34M IOS 50M ANDROID 3817 ANDROID 401F IOS IOS 30 F IOS 33 M ANDROID 28 F IOS 29M WINDOWS 25 $ $ $ $ $ $ $ $ $ $ 70.00 $ 170.00 $ 166.00 S 300.00 $ 59.00 $ 50.00 $ 155.00 $ 482.00 S 431.00$ 55.00 $ 15.00 $2,000.00 45.00 $ 700.00 55.00 $1,000.00 66.00 $5,000.00 89.00 $6,500.00 100.00 $1,200.00 55.00 $ 700.00 67.00 $ 600.00 88.00 $ 500.00 90.00 $ 800.00 375 458 550 742 833 458 558 733 750 3. Add a new column and name it "Megabytes spent, and write a function that gives the number of Megabytes spent if the cost per megabyte is 0.128. 4. On a new sheet named "Statistics", write the appropriate functions that give you the following: i. Number of customers ii. Percentage of customers using IOS operating system under the age of 30 iii. Percentage of customers using Android operating system and having a monthly phone bill less than 100$ iv. Percentage of customers using Windows operating system and having a monthly income between 1000$ and 2000$ v. Average monthly income for each gender
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started