Part I: Essay Write an essay on the first 10 Constitutional Amendments. Your essay must include the following for each amendment: • Explain each individual amendment and the liberties they grant. • The year it was ratified and reasons why. Conclude your essay with your opinion on which of the 10 amendments you feel is most important and give your reasons why you think so. Part II: States of the USA A number from 1-50 is assigned to each of the US States in the map below. List each number in your document and identify: 1. State name 2. State capital 3. Current Governor 4. Current Senator(s) 5. Political affiliations
Write an essay on the first 10 Constitutional Amendments. Your essay must include the following for each amendment:
• Explain each individual amendment and the liberties they grant.
• The year it was ratified and reasons why.
Conclude your essay with your opinion on which of the 10 amendments you feel is most important and give your reasons why you think so.
Part II: States of the USA
Start a document and save it as "American History 1-1 Map".
A number from 1-50 is assigned to each of the US States in the map below. List each number in your document and identify:

1. State name
2. State capital
3. Current Governor
4. Current Senator(s)
5. Political affiliations

1676084112_0350847__811..docx

Before diving into your data, it's always best to first explore the dataset to understand what you are working with.

1. Considering that you will be combining your two tables of data together at a later stage, how many rows of data are available for your analysis?
   Hint: do headers count?

Enter Answer here

2. How are unknown values represented in the dataset?
   Answer here:
3. What is the salary range covered by this dataset?
   $254,000
   $200,000
   $235,500
   $238,500
4. How many unique industries are covered by the dataset?
   Hint: disregard the unknown values.
   59
   60
   58
   61
5. How many unique industries are covered by the dataset?
   Hint: disregard the unknown values.
   61
   60
   58
   59

6. Consider the following point from your boss's email:
   "Where do data scientists work?"
   In its current form, this question is ambiguous as it is unclear whether it is asking about the location where data scientists work or the industry in which they work.
   Think about how you could approach this question, how to best answer it, and how it could be phrased in data terms. Select the most correct option below.
7. What are locations and industries with the highest number (count) of data jobs?
8. What are the locations with the highest proportion (%) of data scientists relative to all data jobs?
9. What are the industries with the highest salary total (sum) for data scientists?
10. What are the locations and industries with the highest number (count) of data scientists?
11. What are the locations and industries with the highest salary total (sum) for data scientists?

7 Now you've explored your data and thought about how to define your questions, you can now transform the data to make it ready for analysis.
In the job_salary table, the job title and job category are currently given together in the Job Title (Job Category) column, e.g: Healthcare Data Scientist (data scientist).

For further analysis, you will need to separate the job title and job category into separate columns (as shown in the image below).
To create a dedicated Job Title column in your job_salary table, which of the following combinations of text manipulation functions could you use?
Note: the X in the formulae below represents the unseparated Job Title (Job Category) column..

=RIGHT(X,FIND(")", X))
=RIGHT(X,FIND(")", X)-1)
=LEFT(X,LEN(X)-FIND("(", X))
=LEFT(X,FIND("(", X)-1)
=LEFT(X,FIND("(", X))

8. Now create a dedicated Job Category column on your job_salary table and use text manipulation functions to split job category from the job title.
   Once you have done this, using your newly created job category column, answer the following to check that you have done this step correctly:
   How many data scientist, data engineer, and data analyst jobs (in that given order) are there?
   311, 123, 103
   109, 315, 119
   313, 119, 109
   319, 113, 109
   303, 119, 109
9. You will also need to join your two sheets of data together, the job_salary table and the company datasets.
   Which method(s) below could you use to join the datasets together? Select all correct answers.
   Use your method of choice to join the datasets together.
   Hint 1: Consider whether your datasets have an equal number of rows to each other.
   Hint 2: We recommend joining the company dataset onto the salary dataset.
   Manually copy the data from one table and insert onto the side of the other table
10. Manually copy the data from one table and insert it below the other table
11. Use INDEX/MATCH
12. Transform the data in both sheets into Tables and then use Excel Power Query to append the tables together
13. Transform the data in both sheets into Tables and then use Excel Power Query to merge Queries
14. There's no need to join the datasets together as you'll analyse each table separately
15. Use VLOOKUP
16. Now that you have consolidated your two tables of data together, answer the following question to check that you have correctly joined your data:
    What is the average salary of a Data Scientist (using your newly created Job Category column) in the Aerospace & Defense industry? Round your answer to the nearest whole number.
    Hint: remember that filters hide rows of data, but don't remove them. Ensure that your calculation only includes filtered cells and not the hidden cells.
    $110,679
    $66,344
    $128,302
    $63,658
    $123,816
    $120,294

The Excel data for this assignment is attached here.
Please find the file:- Dataset - Data Jobs_real_assgnt.xlsx

Note that we can also provide help for this assignment under the statistics assignment help customized services.

Moder World SP23 History Quiz
Qn1. The two different sides fighting in the Russian Civil War were called?

- The Reds and the Whites

Qn2. Which of the following was NOT a reason why the League of Nations was made ineffective?

- France was angered by the proposal and refused to participated

Qn3. The Bolshevik Revolution resulted from...?

-g. B and C

Qn4. What is considered to be one of the most glaring defects of the 1919 peace conference

-The Failure to include representation from Russia and Germany

Qn5. Which of the following countries was NOT involved in the creation of the Versailles Treaty?

-The U.S.

Qn6. By the end of World War I, the economic and financial center of the world had shifted from Europe to where?

-The U.S

Qn7. Which of the following did Lenin NOT call for in his April Theses?

-War and Civil disobedience

Qn8. Which of the following was the name given to the second revolution of the Russian Revolution?

-The Bolshevik Revolution

Qn9. The first revolution of the Russian Revolution led to what?

-The Creation of a Provisional Government

Qn10. The League of Nations...

Suppose that Yuki is selecting her schedule for next semester and has identified four English​ courses, three art​ courses, three psychology​ courses, and four history courses as possibilities to take. Assume that no two of the courses are offered at conflicting times.
​(a) Can the fundamental counting principle be used in solving this​ problem? Explain.
​(b) If any of the courses are offered at conflicting​ times, can you still use the fundamental counting​ principle? Explain.

Hint:_
Notepad:-
The fundamental counting principle states that if a series of tasks is being performed and the first task can be done in a​ ways, the second can be done in b​ ways, the third can be done in c​ ways, and so​ on, then all the tasks can be done in a times
b times c times ...ways.

This question can be answered by our tutors later, or someone can volunteer to provide a solution.

The Fundamental Counting Priciple is going to be used to count the odd​ non-repeating three-digit numbers in our number system. The digits come from the set​ {0,1,2,3,4,5,6,7,8,9}. The first digit​ (in the hundreds​ place) cannot be zero. Since the number is​ odd, the third digit​ (in the ones​ place) must come from the set​ {1,3,5,7,9}.
In order for the Fundamental Counting Principle to apply to this​ problem, this​ 3-part task must satisfy the uniformity​ criterion, meaning the number of choices for any particular part is the same no matter which choice were selected for the previous parts.  
The task of counting these numbers is going to be broken down into three parts. In which order must these be completed in order to satisfy the uniformity​ criterion?