Question: HOW DO YOU SOLVE THIS USING EXCEL ONLY As a business analyst, Julie's recent assignment was to use descriptive statistics to summarize and conveniently present

HOW DO YOU SOLVE THIS USING EXCEL ONLY

As a business analyst, Julie's recent assignment was to use descriptive statistics to summarize and conveniently present the amount of sales tax(as percentages) in the 50 US states and District of Columbia (DC). Using her knowledge of statistics, she was able to draw the histogram (or distribution) of the sales tax data that has a negatively skewed shape. She also calculated the mean to be 4.5% with a standard deviation of 1%. a) One of the states has a sales tax of 5.5%. What is the z-score for this state? b) Predict the percentage of states that charge between 1.5% and 7.5% sales tax. c) In solving the above problem, which rule/theorem did you use?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Question 1 You are the data analyst for a small business and your manager has asked you to analyse the store's data for the past years. Your manager is particularly interested in understanding how...

Explain why it is skewed to the left? Next 5 questions are based on this scenario: As a business analyst, Julie's recent assignment was to use descriptive statistics to summarize and conveniently...

What is the shape of this distribution and what is the median. Please explain Next 5 questions are based on this scenario: As a business analyst Julie's recent assignment was to use descriptive...

Western Region Original Price Sale Price Days to Sell 82 60 20 140 123 26 80 70 16 89 50 72 135 120 18 146 143 109 80 80 79 125 100 130 70 60 100 81 52 96 103 95 14 118 100 33 136 100 101 101 50 55...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

County Alpine Andrews Angelina Appling Arapahoe Atlantic Austin Bailey Ballard Bastrop Baylor Bee Belmont Benewah Benton Borden Bosque Bowie Brazoria Brazos Brewster Briscoe Brooks Brown Burleson...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Instructions: report needs to contain: Introduction that summarizes the problem. paper formatted in APA that answers the questions posed in the problem by communicating the results of analysis....

1 PM665 Project Management Capstone Project Name Your Name Date 2 Table of Contents 1.0 Introduction...

A 6%, 10-year face value 1000 bond with semiannual coupons is issued on September 10th 2015. The bond can be called on any coupon data in 2023 and 2024 at par, and on any coupon data for $ 1050 in...

Given two distributions with the following characteristics: Distribution ADistribution B = 45,600. = 6,333 = 33.40.. = 4.05 If a value from distribution A is 50,000 and a value from distribution B...

The Variance Analysis Cycle begins with what? Group of answer choices Identify root causes Analyze variances Conduct next period's operations Raise questions Take actions Prepare performance report

Consider each of the following cases: Case Accounting Break-Even Unit Price Unit Variable Cost Fixed Costs Depreciation 1 92,400 $ 36 $ 28 $ 828,000 ? 2 138,000 ? 51 2,800,000 $ 1,050,000 3 5,495 113...

10. Understand the differences between the modernist and postmodern views of cultural spaces.

3. Describe how global and domestic economic conditions influence intercultural relations.

3. Values and Language. Although computer-driven translations have improved dramatically over earlier attempts, translation is still intensely cultural. Communication always involves many layers of...