Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus

Authors: Laura Taalman, Peter Kohn

1st Edition

1464153035, 9781464153037

More Books

Students also viewed these Mathematics questions