Please provide an answer that is 100% original and do not copy the answer to thi

Please provide an answer that is 100% original and do not copy the answer to this question from any other website since I am already well aware of this. I will be sure to check this.
Please be sure that the answer comes up with way less than 18% on Studypool’s internal plagiarism checker since anything above this is not acceptable according to Studypool’s standards. I will not accept answers that are above this standard.
No AI or Chatbot! I will be sure to check this.
Your work on the new student committee was a huge success! The director of new student recruitment has requested that you continue your work on the committee. Specifically, the director would like you to distribute a small survey to the students who attended the weekend event, gauging their level of interest in studying at UMGC. The director is interested in obtaining demographic information from the prospective students, the academic program into which they would enroll, and their overall level of interest in attending UMGC. The survey questions and results are below:
Survey questions given to prospective students
What is your age?
Would you live in on-campus housing or off-campus housing?
Into which academic program would you enroll?
How likely are you to attend UMGC in the next year? (Rate: 1–4, 1 is not likely and 4 is very likely)
SurveyStudent
Age
Housing
Academic Program
Likely to attend UMGC
1
18
Off campus
Political science
4
2
19
Off campus
History
1
3
17
On campus
Cybersecurity
2
4
30
Off campus
Nursing
4
5
18
On campus
History
3
6
21
On campus
Psychology
4
7
45
Off campus
Business
2
8
20
On campus
Business
3
9
18
On campus
Accounting
4
10
36
Off campus
Nursing
4
11
25
Off campus
History
2
12
29
Off campus
Sociology
2
13
31
Off campus
Spanish
2
14
19
On campus
Psychology
2
Your first task is to define the data resulting from each survey question as qualitative or quantitative. If the variable is qualitative, indicate if it is nominal or ordinal. If it is quantitative, indicate whether it is discrete or continuous and whether it is interval or ratio (see graphic below).
Next, create a table (a frequency distribution, stem and leaf plot, or a grouped frequency distribution) to organize the data from one of the variables. Include the table in your post. Does including the relative frequency or cumulative frequency make the table more meaningful? Why do you feel this table best organizes the data?
Then, consider how you might visually display the results as a graph (bar graph, Pareto chart, dot plot, line graph, histogram, pie chart, or box plot). Include the graph in your post. Why did you choose this graph? Explain why you believe this graph is the best choice to display the data.
Finally, find the mean, median, and mode for one of the variables. Which of these measures of central tendency do you think is the best choice for “average” and why? Find the range and standard deviation (measures of dispersion) for the variable. What would a narrower or wider deviation signify in the context of this data?
Requirements: There Isn’t a Word or Page Requirement Just Be Sure That You Sufficiently Address and Respond to Each Element of the Discussion Times New Roman Size 12 Font Double-Spaced APA Format Excluding the Title and Reference Pages | .doc file
Please provide an answer that is 100% original and do not copy the answer to this question from any other website since I am already well aware of this. I will be sure to check this.
Please be sure that the answer comes up with way less than 18% on Studypool’s internal plagiarism checker since anything above this is not acceptable according to Studypool’s standards. I will not accept answers that are above this standard.
No AI or Chatbot! I will be sure to check this.
Please be sure to carefully follow the instructions.
No plagiarism & No Course Hero & No Chegg. The assignment will be checked for originality via the Turnitin plagiarism tool.
Please be sure to include in-text citation(s)
Please be sure to use credible or scholarly sources.

Your work on the new student committee was a huge success! The director of new s

Your work on the new student committee was a huge success! The director of new student recruitment has requested that you continue your work on the committee. Specifically, the director would like you to distribute a small survey to the students who attended the weekend event, gauging their level of interest in studying at UMGC. The director is interested in obtaining demographic information from the prospective students, the academic program into which they would enroll, and their overall level of interest in attending UMGC. The survey questions and results are below:
Survey questions given to prospective students
What is your age?
Would you live in on-campus housing or off-campus housing?
Into which academic program would you enroll?
How likely are you to attend UMGC in the next year? (Rate: 1–4, 1 is not likely and 4 is very likely)
SurveyStudent
Age
Housing
Academic Program
Likely to attend UMGC
1
18
Off campus
Political science
4
2
19
Off campus
History
1
3
17
On campus
Cybersecurity
2
4
30
Off campus
Nursing
4
5
18
On campus
History
3
6
21
On campus
Psychology
4
7
45
Off campus
Business
2
8
20
On campus
Business
3
9
18
On campus
Accounting
4
10
36
Off campus
Nursing
4
11
25
Off campus
History
2
12
29
Off campus
Sociology
2
13
31
Off campus
Spanish
2
14
19
On campus
Psychology
2
Your first task is to define the data resulting from each survey question as qualitative or quantitative. If the variable is qualitative, indicate if it is nominal or ordinal. If it is quantitative, indicate whether it is discrete or continuous and whether it is interval or ratio (see graphic below).
Next, create a table (a frequency distribution, stem and leaf plot, or a grouped frequency distribution) to organize the data from one of the variables. Include the table in your post. Does including the relative frequency or cumulative frequency make the table more meaningful? Why do you feel this table best organizes the data?
Then, consider how you might visually display the results as a graph (bar graph, Pareto chart, dot plot, line graph, histogram, pie chart, or box plot). Include the graph in your post. Why did you choose this graph? Explain why you believe this graph is the best choice to display the data.
Finally, find the mean, median, and mode for one of the variables. Which of these measures of central tendency do you think is the best choice for “average” and why? Find the range and standard deviation (measures of dispersion) for the variable. What would a narrower or wider deviation signify in the context of this data?

instruction You should add the Data Analysis add-on to your Excel.Excel for Mac:

instruction
You should add the Data Analysis add-on to your Excel.Excel for Mac: If you’re using Excel for Mac, in the file menu go to Tools > Excel Add-ins. In the Add-Ins box, check the Analysis ToolPak check box, and then click OK. This will load under the Data menu, and you will see “Data Analysis” on the right-hand side of the ribbon. Click Here for a short instructional video.
Excel for Windows: To add data analysis to Excel 2016, load the Analysis ToolPak add-in program go to File>Options>Add-Ins>check the Analysis ToolPak checkbox, and click OK. Click Here for a short instructional video.
View the Excel tutorial videos linked below.
You may also want to re-watch my video on box plots from the material in Chapter 4, relinked below.
Use the attached Excel spreadsheet to answer the descriptive statistics, create a box plot, and interpret your results.
You can answer the questions on the spreadsheet. Save and upload your completed assignment using the Chapters 3 and 4 Excel Assignment: Descriptive Statistics and Box Plots link below.
I must be able to click into the cell for any answer and determine the formula or command used to respond. it should not be pasted answers.
(1) using descriptive statistics to find measures of central tendency and dispersion
(2) how to compute quartiles and percentiles
(3) how to build a boxplot in Excel
(4) Box Plots from the material in Chapter 4
here is the link for the book pdf please used the formula of chapter 3 and 4 from book.
https://dokumen.pub/basic-statistics-in-business-a…

Download this Excel File and open it on your system. When you open it, you shou

Download this Excel File and open it on your system.
When you open it, you should see this image.
I already attached the file and I will list the steps in order
Step 2:
Click on the Data Tab at the on the top of screen and open Data Analysis ToolPak and scroll to “Correlation”
Step 3.
Once you select Correlation and click OK, you will see the following:
NOTE: In the above example, I have highlighted the Var1 Column and the Var 2 Column. Once you click OK, a sheet will open showing the correlation matrix. Note that the first row contains the Labels so the box is clicked.
Step 4
Once you run the correlation, you should see the following:So, the correlation between Var 1 and Var 2 is .776. It is reported as r2 = .776
Step 5
The correlation window allows you to run multiple variables at the same time. So you can select as many columns as you would like to do a correlation. In other words, you can run all the columns at once. What you will get is a matrix showing you all available correlations. In the sample shown in the image, Var1 to Var 4 columns are selected. Go ahead and run that.
Step 6
Once your run that correlation you will get a matrix in the Sheet below that shows all possible correlations. It should look something like this:
Th Corrlation betwe Var and Var 3 is .699 for example. I have blocked out a red box for the correlation between Var 2 and Var 4. Report that correlation as your response to this assignment and confirmation that you were able to complete the analyses.
That’s it. Correlations are straightforward to run. We will talk about the interpretation some more in class.

Part 1 1. Open the Project Spreadsheet: Final Project (Part I) BUS 311 (2020) Te

Part 1
1. Open the Project Spreadsheet: Final Project (Part I) BUS 311 (2020) Tejeda.xlsx
2. Follow the instructions in the spreadsheet.
3. Upload your completed examination here before the deadline. Do not submit exams by email.
Part 2:
I recommend that you create an Excel spreadsheet using either a desktop or laptop computer. I would strongly discourage you from attempting to create this on any of the following devices: Any phone, Any Tablet (with the exception of a Microsoft Surface), Chromebook or Linux-based system. I also recommend that you avoid Apple’s Numbers application as well as a Google doc spreadsheet.
Create the following spreadsheet:
Column A: Observations. Use numeric or text to identify them. For example, “OBS 1” or simply “1”.
Column B: The last 20 days of observed low temperatures in your home town.
Column C: The last 20 days of observed low temperatures for Miami.
Guidance: These data are available through any weather service- simply request previous or historical data available when viewing the entire month.
Column D: Visit a traditional retailer with an online presence like Publix, Target, or Walmart and gather the name and price of 10 grocery items from a national maker.
Column E: Visit an online retailer such as Amazon and gather the name and price of the exact same 10 grocery items selected at brick and mortar retailer.
Guidance for Columns D&E: I suggest these be canned foods, bread, frozen foods- anything that is pre-processed and a national brand. The items should be exactly (or as close as possible) the same items just at two retailers. Avoid the deli, bakery, meat, and produce departments as these are internally prepared r seasonally available.
Column F: Select 10 male friends and enter their ages.
Column G: Select 10 female friends and enter their ages.
Column H: Gather the GDP data of your country of Origin for the past 10 years.
Column I: Gather the GDP data of a country other than USA or your country of origin for the last 10 years.
Column J: Gather the GDP data of the USA for the last 10 years.
Guidance: GDP data is available at this web site; https://data.worldbank.org/indicator/ny.gdp.mktp.kd.zg
For the GDP website, simply enter the name of the country and use the cursor to gather the data. Note: some countries will not have a reporting convention. If your country or origin or your selected country does not have this information, simply select another location of interest.
Finally, document all the data collected beginning in column J. Clearly provide the detail that allows a person looking at your data set to understand all the variables and all the information that is present.
Once you are done with the Excel file, answer the following questions. Remember to provide evidence and screenshots of the analysis embedded in the results, as we discussed in class.
Final Project Questions
Is there a statistical difference in temperatures between your selected cities?
Is there a statistical difference in age between your male and female friends?
Is your age statistically different that your male friends?
Is your age statistically different that your female friends?
Are the prices of online retailers statistically less expensive than their traditional counterparts?
Are the prices of the online retailers statistically different than their traditional counterparts given that they are exactly the same products?
Is there a relationship between the GDP data from the two countries?
Does GDP of the USA have any bearing on the GDP of your country of origin of your first selected country?
Does GDP of the USA have any bearing on the GDP of your country of origin of your second selected country?
When you have completed your analyses and clearly labelled all components and results and stated those results, submit your final Excel spreadsheet
so you should send me two different things one for the first part and one for the second!!!