04 Jun Question Please submit your answers to below questions
Question
Please submit your answers to below questions all in one excel workbook and each question in a different worksheet. Email me an excel file with seven sheets with name sheet1, sheet2… You may work on these questions on a group of at most three students but each student has to submit her or his own report. The excel file name needs to be your panther ID and on the top of sheet1, put your first, last name, and other group members you worked with. I demonstrated you how to answer to some of the questions during the class but I need you to redo them and submit your answers completely.
1) [60 points]Calculate the expected value and standard deviation of customer review rate for Apple ipad mini using link below:
http://www.amazon.com/dp/B00746W9F2/ref=psdc_1232597011_t1_B009W8YQ6K#customerReviews
2) [15 points] Find the probability of having at least 20 success in 70 trials when the success probability is 0.3
3) [15 points] Find the probability of having at least 6 car passing through one of Sunpass toll in turnpike highway which has the average of 3 car per minutes
4) [15 points] The probability of having the income of a household between 50,000 and 70,000 when it has the normal distribution with mean of 75,000 and standard deviation of 40,000
5) [15 points] For the question above, what is the household income that 70 percent of households’ income is above that?
6) [40 points] Draw two normal distribution curves in one chart with mean of 10 and standard deviation of 2 and 2.5.
7) [60 points] Shade area below the normal curve with normal distribution of N(10,2) from x=8 to x=13. {Hint: You may use the chart layout as Y Error Bar with minus display, 100 percentage error Amount, no caps and line width oh of 4} {Hint2: more on this webpage:http://www.exceluser.com/excel_dashboards/normal-curve-new-excel.htm}
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.