Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sir i am stuck for this question only part 2 and 3 Histogram on Google sheet (link are just ) https://youtu.be/0jFCBbvSS4U You MUST use correct

Sir i am stuck for this question

only part 2 and 3

Histogram on Google sheet (link are just )

https://youtu.be/0jFCBbvSS4U

image text in transcribedimage text in transcribedimage text in transcribed
You MUST use correct commands in Excel or Google sheets to complete this project. Please make sure you organize your file neatly. Write the question number and actual question you are solving and put things in order in an organized manner. Use the appropriate notation and tables as demonstrated in the eText and course materials. Round all numbers to the nearest whole number, and round the standard deviation to the hundredths place for all problems on this project. Make sure your project is neatly typed, includes a cover page, and each portion is labeled (include original problem and problem number) Here are some resources to help create graphs: - Data Set for the project . Google Sheets Calculations Video . Pie Chart in Google Sheets - Organizing data to make pie charts in Google Sheets and more detail on how to create - Bar Graphs in Google Sheets - Histogram in Google Sheets - Making Frequency Distribution Tables You will use the following data set to answer all part of the project. This data set is the overall Enrollment by Race/Ethnicity for CCA from 2011-2020. 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Total African American 3044 3289 3307 2884 2704 2352 2330 2380 2287 2476 27053 American Indian/Alaskan Native 142 224 207 226 197 171 191 234 204 199 1995 Asian/Pacific Islands 788 893 932 912 893 817 883 1035 985 1121 9259 Hispanic 1903 2161 2394 2453 2543 2480 2959 3517 3507 4048 27965 White 5015 5308 5266 4886 4505 4042 3971 3809 3616 3713 44131 Unknown 742 702 692 582 515 667 681 803 753 636 6773 1) Find the mean, median, mode, sample standard deviation, and sample variance for CCA Student enrollment data set for each race/ethnicity, each year, and for the Use excel or Google Sheets. The Spread Sheet for this data is here. 2) Find the total student enrollment for each year by adding the number of students by race/ethnicity. Use the total data to create a Relative Frequency Distribution. Organize the data set on student enrollment by creating a frequency distribution and include the relative frequency. Group the data into logical equal intervals. You may want to start with 10,000 s x

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

Step: 3

blur-text-image

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

Nonlinear Systems And Their Remarkable Mathematical Structures Volume 3, Contributions From China

Authors: Norbert Euler, Da jun Zhang

1st Edition

1000423301, 9781000423303

More Books

Students also viewed these Mathematics questions

Question

=+c) In what month of the year are gas prices highest?

Answered: 1 week ago