Загрузка данных


Из двух нормально распределенных генеральных совокупностей X и Y извлечены выборки:

Совокупность	Выборка
X	{-0.61; -1.46; 0.58; 1.56; -1.11; 1.53; 4.7; 1.86; 1.46; -1.69; 2.61; 1.72; -0.25; -1.12; -1.25; 0.17; -1.54; -0.39; -0.44; 2.01; 0.39; -0.61; 0.1; -0.33; 1.68; -0.56; -0.04; -1.36; -1.74; -0.83; 0.04; 2.81; -0.17; 2.17; -1.22; -0.18; 0.24; 1.94; -0.8; 0.6; -0.73; 2.18; 1.84; -0.14; -1.57; 0.07; 2.47; -0.73; -1.82; 0.85; 2.42; -0.3; -2.02; 0.52; -1.19; 2.82; 2.68; 0.43; 0.13; -0.51; -0.71; -1.52; -0.32; 0.42; -0.02; 0.3; 1.13; 1.2; -0.24; -2.47; -0.39; 0.92; 0.25; 0.67; -0.18; 0.89; -0.41; 0.55; -1.1; -0.16; -2.22; 0.11; -1.19; -1.82; -0.15; 0.93; -0.88; -2.72; 1.46; -0.94; 0.18; 0.15; 1.59; 1.59; -2.81; 1.91; 0.27; -1.04; 1.64; 1.28; 2.82; 0.23; -1.86; -1.41; -0.49; 1.35; -2.16; -1.85; -0.15; -3.36; -1.53; -2.9; -0.56; -2.06; -1.4; -1.2; 0.32; -0.04; 0.57; -1.55; -0.41; -0.49; 1.28; -2.1; 1.18; -0.05; -0.44; 0.29; 1.02; 1; 0.52; -3.46; 0.98; 0.26; 0.6; -1.64; 1.42; -0.44; 0.22; -1.58; 0.18; -0.3; -1.14; 1.53; -1.65; -0.55; -0.73; -1.29; -0.61; -0.64; 1.96; -0.47; -0.05; 0.54; -0.97; -2.13; -1.93; 0.19; 1.09; 1.05; -0.4; -0.76; 1.09; 1.95; -0.71; -1.52; -3.09; -3.27; -1.09; -0.3; -0.89; -0.19; -0.01; 1.26; 1.28; 2.62; -1.49; 0.69; -2; -4.22; -1.23; -3.42; 1.58; -3.04; 1.39; 2.54; -0.51; 0.54; 0.53; 0.12; -0.18; -1.77; 1; 0.83; 1.19; 0.26; 1.76; 2.04; 0.54; 0.32; -0.72; 1.93; -0.17; 2.01; -0.72; -0.39; -2.51; 0.63; 0.85; 0.69; -1.28; -1.2; 1.95; 0.27; -1.02; -1.53; 0.02; -1.44; -4.63; 0.27; -1.79; 1.52; -0.46; -1.8; -0.78; -1.46; 1.86; -0.42; 0.44; 0.07; 1.83; 0.84; -0.1; -1.43; 1.06; 1.12; 0.97; -0.65; -2.12; -0.93; 1; -1.17; -0.25; 0.4; -1.77; -1.67; -0.2; -0.4; -0.2; 1.9; -1.86; 0.35; 2.55; 0.78; 1.07; -0.77; 2.75; 1.31; 0.52; 2.95; -1.06; 1.52; 0.78; 0.54; 0.53; -0.56; -0.03; 1.81; 0.79; -1.73; 1.05; -0.92; 2.29; -0.49; -0.36; 0.07; -0.7; 0.2; -0.78; -1.64; -0.09; -0.07; -0.64; -1.34; 2.49; -0.84; -0.66; 1.57; -0.52; 0.93; -2.2; -1.22; -0.74; 3.11; -0.03; 0.5; 0.72; 1.45; 0.78; -0.06; 0.81; -0.25; 0.37; -0.34; 0.25; -3.23; 0.65; -0.9; 1.28; -2.22; -1.28; 2.31; -0.29; 1.35; 0.88; -1.38; 1.63; -0.4; 0.71; 0.78; 0.97; -3.68; 1.99; 0.46; 2.16; -0.69; 0.21; 1.26; -0.18; -0.35; -0.01; -0.11; 1.01; 2.15; -0.7; -4.01; 1.46; 2.17; 1.1; -0.13; -1.2; 0.55; -0.2; 0.55; -2.45; 2.52; -0.74; -1.41; -0.96; -0.63; 2.04; 1.22; 0.62; 1.3; -1.28; 3.4; -1.83; -1.5; -1.53; -0.74; 1.2; -0.47; -0.82; 1.84; 0.6; 0.45; 2.8; -0.41; 1.88; -0.29; 0.57; -0.82; 2.39; 2.01; -0.36; 0.29; -0.3; 0.6; 0.66; 2.67; -0.02; 0.06; 0.43; -0.61; -2.2; -0.46; -0.77; -0.54; 1.12; -0.56; 0.85; -1.89; -1.35; 0.45; -1.22; -0.43; 0.08; 1.2; -0.35; -0.87; 0.16; 1.35; 0; 1.2; 1.34; -1.04; -0.39; 1.15; 1.62; 3; -0.65; -2.35; 0.25; 0.47; 1.54; -3.2; 0.67; 1.2; -1.07; -0.08; -0.3; -1; -0.24; -1.64; 1.17; -1.54; 2.13; -0.61; -2.9; -0.11; -2.68; 1.21; 2.12; 0.14; 0.65; 0.56; 1.4; -0.83; 2.02; 1.14; -1.8; -0.35; -2.15; 0.6; 0.49; -0.37; 0.17; -2.04; 0.39; -2.07; -1.98; 1.88; 2.12; 1.24; 0.64; -0.39; 2.73; 0.99; -2.98; 0.9; 0.25; -0.53; 0.42; -2.72; -0.14; -0.13; -1.05; -2.09; 2.38; 0.58; 1.82; 2.07; 0.9; -1.02; 0.1; 0.43; 0.55; 2.93; 3; -0.74; 0.4; -0.46; -2.39; 0.27; 1.94; 1.51; -0.37; 1.66; 0.54; -2.4; 0.27; -1.42; 0; -1.1; 0.32; -1.33; -0.33; -0.09; 2.96; 0.68; -0.9; -0.94; 0.51; 0.03; -0.98; -0.54; 1.28; -2.4; -0.44; 0.74; 1.41; 0.42; 1.94; -0.24; -0.68; -1.68; -0.18; -0.23; 1.87; -2.17; 1.43; -0.12; -0.48; 1; -0.76; 2.23; 0.72; -0.19; -2.03; 0.63; -1.84; 1.47; -0.76; -1.98; 0.62; 0.08; 0.37; -1.31; -0.44; -3.18; 0.09; 0.27; 0.99; 2.09; -0.89; 1.75; 2.14; 0.98; -0.37; 2.35; 1.59; 0.31; 2.51; 3.24; 0.5; -0.07; 2.57; -1.26; -0.98; 0.44; 2.76; -0.27; 0.11; 0.14; -0.76; -0.16; 1.07; 2.41; -0.12; 1.74; -1.06; -1.06; -0.16; 0.19; 0.45; -0.3; 2.53; -0.21; 0.94; 0.27; 2.6; -0.84} 
Y	{0.29; -2.36; 1.18; 0.1; -0.28; 0.71; 1.04; 0.26; 2.39; 1.43; 0.55; 1.91; -1.15; 0.15; -0.2; 0.12; 2.94; 1.22; 0.41; 0.81; 1.09; -0.74; -1.35; 0.62; 0.28; 0.1; 0.26; 0.78; 0.1; 1.5; 0.89; 1.1; 2.31; 0.09; -0.53; -2.51; 1.78; 0.64; 1.79; 0.29; -0.81; 0.29; -0.1; 1.11; 0.52; -0.81; 0.77; -1.4; 2.68; 2.09; 1.15; -1.38; 0.21; 1.74; -0.84; 0.56; 1.95; 1.3; -2.47; -0.33; -0.09; -2.21; 0.77; -0.05; -0.23; -1.52; -1.23; 1.5; -0.43; 1.25; -0.72; 0.68; -0.36; 0.56; 0.96; -3.07; 0.53; -1.15; 0.83; -0.1; -0.09; 3.44; -1.03; 1.21; 0.45; 0.9; 0.34; -0.43; 2.15; -1.3; 0.55; 0.87; 0.34; 1.82; -1; 0.1; -0.12; -0.72; -1.48; 1.76; 1.59; 0.82; -0.66; 1.7; 0.67; 0.2; -1.05; 0.57; 1.97; 0.28; -1.39; -0.44; 0.43; -1.02; -0.89; -0.5; -0.64; 0.96; 4.1; -0.28; 2.28; 2.32; 0.64; 0.27; -0.28; 0.56; 0.04; 1.6; 0.38; 0.61; -1.23; -0.9; 2.05; -0.12; 0.99; 0.31; -0.3; 1.45; 1.23; -1.41; 0.62; -0.44; 0.06; 0.22; 0.37; 1.25; 0.14; 1.28; -1.89; -2.41; -1.63; 1.73; -0.11; 2.27; 0.59; -1.11; 0.17; -0.32; -0.12; 0.68; -0.24; -0.92; 0.33; -1.04; -2.34; 1.31; -1.4; 1.65; -0.63; 0.94; 0.45; 0.11; -0.67; 2.65; -0.2; -0.19; -1.59; -0.96; 1.94; 0.65; 0.14; 1.21; 3.18; -1.01; -0.76; -2.68; -1.88; -0.29; 2.59; 1.3; 1.07; 0.24; 1.71; -0.56; -1.62; 0.54; 1.31; 0.83; 1.28; -1.38; -0.35; -1.3; -0.93; 2.89; -1.02; 0.28; -1.56; 0.57; -1.52; 0.64; 1.38; -1.86; -0.05; 0.67; 0.68; -0.51; 1.29; -0.16; -0.79; -0.19; 0.58; -1.22; -0.77; 0.15; 0.9; 1.06; 0.48; 2.51; 1.06; -0.04; -2.62; 0.16; 0.42; 0.22; 0.75; -1.26; 1.37; 0.15; -1.46; 1.11; 0.06; -1.87; 0.27; 0.9; -3; -1.93; 0.78; 1.48; -0.93; 1.05; -0.86; 2.25; -0.33; 1.15; -0.17; -0.82; -0.77; 2.79; 1.03; 3.67; 0.4; -0.94; 0.65; 1.72; 1.35; 0.64; -0.29; 2.31; 1.36; -0.77; 0.56; 1.43; 0.86; 2.34; 0.3; 0.23; -0.16; 1.5; 1.02; -0.99; -3.02; -0.21; 0.92; 1.31; 1.73; -0.74; 1.13; 1.05; 0.76; -0.78; -1.07; 0.81; 2.1; 1.84; 1.32; 0.82; 1.75; -2.7; 1.06; 0.87; 1.24; 0.85; 0.77; -1; 0; 0.43; -0.64; -0.02; 2.12; 1.2; -0.23; -0.81; 0.18; -0.33; -1.68; -0.75; 1.47; 1.63; 0.52; 0.31; -0.24; -0.21; 0.9; -0.08; -0.64; -0.95; 2.44; -0.05; -1.8; -2.05; 1.19; 1.54; 1.24; -0.17; -0.65; 0.27; 1.26; -2.01; 0.57; 0.86; 0.2; 0.04; 0.93; -0.71; -0.55; 1.27; -0.23; 2.09; 1.59; 1.4; 0.22; -0.54; 2.42; -0.35; 0.63; -0.36; 0.78; 0.62; 0.89; -0.55; -1.42; 0.57; 2.18; 0.08; -1; -0.36; 0.8; 0.73; 0.87; 0.06; 1.23; 0.91; 0.44; 2.14; 0.22; 0.62; 1.26; -0.94; -1.66; -0.34; 0.39; 1.03; -0.34; -0.14; -0.87; 1.07; -0.37; 2.16; 0.9; 0.8; -0.76; 0.77; -1.19; 1.01; -0.05; 0.21; 0.24; -1.26; -0.65; 0.37; 1.17; 0.89; -2.46; 0.05; 0.81; -0.26; -1.28; -1.34; 0.64; -0.85; 2.23; 2.64; 0.18; 1.39; 1.92; 0.35; -0.45; 0.8; 1.49; 0.92; 1.94; 0.4; -1.75; -1.03; -0.9; 0.08; 3.52; 2.21; -0.03; 1.48; -0.48; -1.38; 1.92; 0.95; -0.02; -1.06; -2.6; -1.83; 1.21; -0.8; 1.02; 0.93; 0.24; -3.5; 0; -1.7; -1.67; 2.27; 1.98; -0.86; 1.23; -0.13; 1.42; 1.82; -0.03; -0.71; -0.9; 1.13; -0.6; 0.88; 2.06; -1.4; -1.75; 1.41; 0.91; -1.55; -1.25; 3.15; -0.59; -0.1; -2.58; -0.04; -0.58; -0.95; 0.32; -0.21; 0.44; 0.63; -1.47; -1.52; 1.78; -0.49; 0.77; -1.07; 1.32; 1.17; -1.04; 0.07; -1.31; -0.06; 1.07; -1.05; 0.44; -0.34; 1.18; 0.92; 0.56; -0.63; -0.43; 0.91; -1.24; -0.77; -2.74; 1.23; -1.22; -1.07; 1.02; 1.88; 0.09; -1.34; -0.21; 2.25; -0.44; 0.35; 0.24; 0.81; -0.19; 1.48; 0.16; 0.59; 0.2; 0.19; 1.3; -2.48; -1.79; 2.31; 0.85; -1.13; -0.39; 1.95; 0.43; 1.77; -0.14; -0.19; 2.46; -0.25; -4.71; -1.53; 0.01; 0.38; 2.05; -1.92; 0.07; -0.38; 0.54; -1.61; 0.87; 0.69; -0.13; 1.34; -0.23; 0.37; 1.84; 0.55; -1.92; 0.26; 0.62; -1.83; -0.8; 0.05; 1.8; 1.5; -0.22; 0.74; 2.28; -0.01; 0.46; 2.11; -0.35; 0.26; -1.14; -0.61; 0.67; 0.32; -0.71}
Используя Excel и/или R(RStudio), выполните следующие задания и заполните соответствующие поля форм ниже.


п.	Балл	Задание	Ответ
1.	2	Оценка (несмещенная) дисперсии совокупности Y	Ответ за часть 1

п.	Балл	Задание	Ответ
2.	–	На уровне значимости α=0.01
 проверьте нулевую гипотезу H0:E(X)=E(Y)
 (без каких-либо предположений о равенстве дисперсий) при альтернативной гипотезе H1:E(X)≠E(Y)
, вычислив значение P-value
2.1.	2	P-value	Ответ за часть 2 и координаты 1
2.2.	2*	Имеются ли основания отвергнуть H0:E(X)=E(Y)
 в пользу H1:E(X)≠E(Y)
 на заданном уровне значимости?	Ответ за часть 2 и координаты 2

 

п.	Балл	Задание	Ответ
3.	–	На уровне значимости α=0.01
 проверьте нулевую гипотезу H0:Var(X)=Var(Y)
  при альтернативной гипотезе H1:Var(X)>Var(Y)
, вычислив значение P-value.
3.1.	2	P-value	Ответ за часть 3 и координаты 1
3.2.	2*	Имеются ли основания отвергнуть H0:Var(X)=Var(Y)
 в пользу H1:Var(X)>Var(Y)
 на заданном уровне значимости?