﻿ Others | Excel- bir olasılık sorusuna göre data analizi

# Excel- bir olasılık sorusuna göre data analizi

1 kişi
bu görevi tamamlamak istiyor

### Görev Detayı

Merhaba,
Aşağıdaki soru için bir word dosyası ve işlemlerin yapıldığı excel dosyasına ihtiyacım var.

Suppose you roll two 10-sided dice. Let X1, and X2 the outcomes of
the rolls of these two fair dice which can be viewed as a random sample of size 2 from a uniform distribution on integers.
a) What is population from which these random samples are drawn? Find the mean (μ) and variance of this population (σ2)? Show your calculations and results on your Word/PDF file.

b) List all possible samples and calculate the value of the sample mean ̄(X) and variance (s2) for each sample? Show this work on your Excel file.

c) Obtain the sampling distribution of X ̄ from this list by creating a fre-
quency distribution table. Then calculate relative frequencies, i.e., f(x), which give the probabilities of the sampling distribution of X ̄, and calculate the mean of the sampling distribution, i.e., xf(x). Check if that equals to (μ). Share these frequency and relative frequency tables on your Word/PDF file.

d) Make a Histogram for the sampling distribution of X ̄ you have obtained in (c). Use the Data Analysis Toolpak in Excel to make the Histogram. For Bins, use the Row Labels of the frequency tables you have created in (c).
e) Calculate the Skewness and Kurtosis for the sample mean ̄(X) you have obtained in (b). Explain your results. Do the Histogram in (d) and your results in (e) show any indications that the data is symmetrically distributed? Explain.
f) Obtain the sampling distribution of (s2) from the list in (b) by creating a frequency distribution table. Then calculate relative frequencies, i.e., f(s2), which gives the probabilities of the sampling distribution of (s2), and calculate the variance of the sampling distribution, i.e., s2f(s2). Check if that equals to(σ2). Share these frequency and relative frequency tables on your Word file.
g) Make a Histogram for the sampling distribution of (s2) you have obtained in (f). Use the Data Analysis Toolpak in Excel to make the Histogram. For Bins, use the Row Labels of the frequency tables you have created in (f).
h) Calculate the Skewness and Kurtosis for the sample variance (s2) you have obtained in (b). Explain your results. Do the Histogram in (g) and your results in (h) show any indication that the data is symmetrically distributed?
Explain.

#### Bütçe: 50 TL

İşin Yapılacağı Konum: ONLINE
Görevin Başlangıç Tarihi: 21-03-2021
Görevin Bitiş Tarihi: 24-03-2021
Kategori: Ders / Çeviri