For the statistics project you are completing in this course, you will need to select a relevant topic that will allow you to gather both qualitative and quantitative data. You may gather data from a group of your choice using a data collection instrument (survey or data mining) that you design. Using the results of that collection instrument, you will create a data set, analyze the data, and create a professional report showing the results of the data that you collected.For this assignment you will choose a topic and create a data collection instrument. When selecting a topic, remember you need to collect both quantitative and qualitative data. Data collection could be done in the form of a survey via a medium such as Survey Monkey or Facebook or through available workplace content such as sales orders. You will want to collect data from approximately 30 observations. This means you will want to survey at least 30 people or select data from 30 different sales orders.Submit the topic of the study, a rationale (one or two paragraphs) outlining the purpose of the study, and the data collection instrument you created as a Word document. Include relevant survey links if the data is being collected digitally.APA format is not required, but solid academic writing is expected.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.ta Collection 1Unsatisfactory0.00%2Less than Satisfactory74.00%3Satisfactory79.00%4Good87.00%5Excellent100.00%100.0 %Content 10.0 %Topic and Rationale Topic and rationale are not included.Topic and rationale are incomplete or incorrect.Topic and rationale are included but lack detail.Topic and rationale are complete and include relevant details.Topic and rationale are clearly explained and include extensive details.80.0 %Data Collection InstrumentData collection instrument is not included.Data collection instrument is incomplete or incorrect.Data collection instrument includes both qualitative and quantitative measures that can be used to create data sets.Data collection instrument is well crafted and includes both qualitative and quantitative measures that can be used to create data sets.Data collection instrument is expertly crafted and includes both qualitative and quantitative measures that can be used to create exceptional data sets.10.0 %Mechanics of Writing (includes spelling, punctuation, grammar, and language use)Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is employed.Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied.Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed.Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech.The writer is clearly in command of standard, written, academic English.100 %Total Weightage Administer the data collection tool you created in the Topic 2 assignment. Using the data you collect, create an Excel table and complete the items below.Create two frequency tables based on two separate questions from your survey.Create a bar graph and a pie chart based on the data in the frequency tables.Determine the class intervals and create frequency distribution for each of the frequency tables.Create one frequency polygon of the data from the frequency distribution.Create an individual Excel document for each of the required items.Creating a Data Set 1Unsatisfactory0.00%2Less than Satisfactory74.00%3Satisfactory79.00%4Good87.00%5Excellent100.00%100.0 %Content 25.0 %Frequency TablesFrequency tables are not included.Frequency tables are incomplete or incorrect.Frequency tables are included but lack detail.Frequency tables are complete and include relevant details.Frequency tables are clearly explained and include extensive details.25.0 %Bar Graph and Pie ChartBar graph and pie chart are not included.Bar graph and pie chart are incomplete or incorrect.Bar graph and pie chart are included but lack relevant details.Bar graph and pie chart are complete and include relevant details.Bar graph and pie chart are expertly constructed.25.0 %Class Intervals and Frequency DistributionClass intervals and frequency distribution are not included.Class intervals and frequency distribution are incomplete or incorrect.Class intervals and frequency distribution are included but lack relevant details.Class intervals and frequency distribution are complete and include relevant details.Class intervals and frequency distribution are expertly constructed.25.0 %Frequency PolygonFrequency polygon is not included.Frequency polygon is incomplete or incorrect.Frequency polygon is included but lacks relevant details.Frequency polygon is complete and includes relevant details.Frequency polygon is expertly constructed.100 %Total Weightage APA format is not required, but solid academic writing is expected.This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

Determine the outcomes of hedges against interest rate and currency risks using the information provided.The assignment must be submitted as a Word document.