老司机代写基础统计学Statistics作业excel assignment

扫一扫又不会怀孕，扫一扫，作业无烦恼。
**留学顾问の QQ：2128789860**
**留学顾问の微信：risepaper**

此次作业主要考察统计学的基本操作，项目内容都在excel表格中完成，part 2-8分别对应不同的考察内容，比如charting，ANOVA，和pivot

Descriptive statistics
■ Collecting, presenting, and describing data
Inferential statistics
■ Drawing conclusions and/or making decisionsconcerning a population based only on sample data
Probability
■ Chance that a particular event will occur

Part 2 Charting – Identify each state # with its 2-digit abbreviation.
Use the summary data (in yellow) for each of the charts.
Label appropriate axes.Charting – Identify each state # with its 2-digit abbreviation.
Use the summary data (in yellow) for each of the charts.
Label appropriate axes.

Part 3

Calculate Descriptive Statistics, with a 99% confidence interval from Data Analysis, for the in-state tuition for your combined data. For your four states combined, display the full set of Data/Data Analysis/Descriptive Statistics below, with one aggregate + 99% confidence level value for your four states combined.

Part 4

Pivot Table: With any three variables in the data set, create either a table or a graphic using Pivot Tables.

See the two YouTube videos listed above.

1. Copy all your data for your four states into the Pivot space (or new spreadsheet).
2. The pivot table report/chart needs to reflect at least 3 of these variables.
3. Metric (counts, averages, etc.) are appropriate.
4. The chart must make sense.
5. Include appropriate title/labels.

Part 5

1. Display only the relevant column(s) of data, with column headings.
2. Please include your Excel full correlation matrix over the variables.
3. Apply conditional formatting over the correlation matrix.
4A. Select and copy 2 of the variables; plot the data for these 2 variables as one combined scatter diagram reflecting the data for your four states in the aggregate.
4B. Include the title, and label both axes.

Part 6

Statistically, is the mean Math SAT score for public colleges/universities the same than for private colleges/universities? α = 0.10.
1A. Display only the relevant column(s) of data, with column headings.
1B. Sort the data by public/private.
Statistically, is the mean Math SAT score for public colleges/universities the same than for private colleges/universities? α = 0.10.
1A. Display only the relevant column(s) of data, with column headings.
1B. Sort the data by public/private.