Category: Statistics

Answer all questions except question 2,3, and 4.
Please read instructions carefully and answer the questions correctly.
Let me know if any files don’t open.
Thanks.

please follow all instructions
I am uploading assignment 1 so you can have some guide
use JASP software.
I uploaded sources to use.
THIS IS ASSIGNMENT 3

Please complete the remaining questions, beginning at 28.
The link to the training video is embedded in the file.

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…

Hello Bro,
I need assistance with Stats Week 4
Will send once matched, just give yr best as always
Cheers

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) 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!!!

Amount of work:
2 pagesDOUBLE
Subject:
Statistics
Type of paper:
Essay
Type of work:
Writing from scratch
Paper Format:
A
Academic Level:
Professional
Sources needed:
No specific sources required
Preferred language style:
US English
The effect of depression on academic achievement in teenagers
I’ve included the instructions along with an example. NOTE: my topic is different from the example.
Here is also a link -that the professor gave us- that can help you with this assignment: http://alexcasteel.com/courses/edco-745/data-scree…
My topic is: The effect of depression on academic achievement in teenagers

Amount of work:
2 pagesDOUBLE
Subject:
Statistics
Type of paper:
Essay
Type of work:
Writing from scratch
Paper Format:
APA
Academic Level:
Professional
Sources needed:
No specific sources required
Preferred language style:
US English

Amount of work:
2 pagesDOUBLE
Subject:
Statistics
Type of paper:
Essay
Type of work:
Writing from scratch
Paper Format:
A
Academic Level:
Professional
Sources needed:
No specific sources required
Preferred language style:
US English