logo

Crowdly

Browser

Додати до Chrome

BU6015 - Business Analytics

Шукаєте відповіді та рішення тестів для BU6015 - Business Analytics? Перегляньте нашу велику колекцію перевірених відповідей для BU6015 - Business Analytics в moodle.polytechnic.bh.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

What menu option/functionality in Excel creates a chart allowing data to be sliced, diced, filtered, conditionally formatted, and be modelled with sparklines?
❌
❌
✅
❌
Переглянути це питання

A human resource survey asks employees to answer the question: How long is your commute from home to work? Employees are to select one of the following five choices.

0–2.0 miles

2.1–5.0 miles

5.1–10.0 miles

10.1–20 miles

More than 20 miles

This is an example of which type of data?

❌
❌
❌
✅
Переглянути це питання

Which type of analytics will forecast product demand?

❌
❌
✅
❌
Переглянути це питання

A new business, CoolIT, sells items to keep you cool when outside. Its products include coolers, generators, floats, and other water accessories designed to beat the heat. CoolIT has been spending money on innovative advertising in hopes of increasing its sales revenue. A CoolIT business analyst ran a regression using 36 months of data using the Excel Data Analysis Toolpak. The output is shown below. What is the slope of the line?

The excel sheet titled summary output contains 3 tables. The table at top contains 2 columns and 6 rows with the following sub-title: regression statistics. The row entries are as follows: row 2 - multiple R; 0.95011488. Row 3 - R square; 0.90271829. Row 4 - adjusted R square; 0.89985706. Row 5 - standard error; 6748.44918. Row 6 - observations; 36. The table below titled Anova contains 6 columns and 4 rows. The headings of columns 2 to 6 are as follows: d f; S S; M S; F; significance F. The row entries are as follows: row 2 - regression; 1; 14368384267; 1.44E+10; 315.5004; 8,92218E-19. Row 3 - residual; 34; 1548413256; 45541566; blank; blank. Row 4 - total; 35; 15916797524; blank; blank; blank. The table below contains 7 columns and 3 rows. The headings of columns 2 to 7 are as follows: coefficients; standard error; t stat; P-value; lower 95%; upper 95%. The row entries are as follows: row 2 - intercept; -836512.83; 54148.06535; -15.4486; 6.16E-17; -946554.9386; -726470.7216. Row 3 - advertising expense; 163.271654; 9.192016768; 17.76233; 8.92R-19; 144.5912287; 181.9520799.

0%
0%
0%
0%
Переглянути це питання

Identify the chart type for the exhibit below.

The map of the United States shows the sum of sales in the form of small and big spheres with 6 various amounts and colors.

❌
❌
✅
❌
Переглянути це питання

Based on these regression results from Lab 5.6 Excel: Forecasting Product Demand Using Regression, which independent variables are significantly related to forecast demand?

Under regression statistics, the following values are shown: Multiple R, 0.891401552. R square, 0.794596727. Adjusted R square, 0.780591959. Standard error, 4.286745807. Observations, 48. In the ANOVA table at the center, values are shown as follows: Regression: d f, 3. S S, 3127.861777. M S, 1042.621. F, 56.73758. Significance F, 3.6376E minus 15. Residual: d f, 44. S S, 808.5523431. M S, 18.37619. Total: d f, 47. S S, 3936.41412. In the table at the bottom, the entries are shown as follows: Intercept: Coefficients, negative 123.7576339. Standard error, 22.11431598. t Stat, negative 5.59627. P value, 1.32E minus 06. Lower 95 percent, negative 168.3261093. G D P: Coefficients, 2.162221318. Standard error, 0.212246208. t Stat, 10.18733. P value, 3.76E minus 13. Lower 95 percent, 1.734467193. Weather (average Fahrenheit): Coefficients, 0.202019743. Standard error. 0.043196935. t Stat, 4.676715. P value, 2.78E minus 05. Lower 95 percent, 0.114962041. Holiday: Coefficients, 7.513785459. Standard error. 1.745077976. t Stat, 4.305702. P value, 9.17E minus 05. Lower 95 percent, 3.99681189.

❌
❌
❌
✅
Переглянути це питання

________ explains the extent to which a data item gains or loses magnitude or value.

❌
❌
✅
❌
Переглянути це питання

Based on this pivot table in Lab 1.3 Excel, Assessing Product (SKU) Profitability, which product number is the most profitable per dollar of sales?

S K U, description, sales price per pound, cost per pound, gross margin, and gross margin percentage are the column heads of the pivot table with dropdown buttons. The row entries are as follows: F R T hyphen S A R, salal berry, 1.12, 0.66, 0.46, and 0.411. F R T hyphen R E N, redcurrant, 1.42, 0.85, 0.57, and 0.401. F R T hyphen A V D, avocado, 1, 0.59, 0.41, and 0.410. F R T hyphen P U E, purple mangos, 1.01, 0.59, 0.42, and 0.416. F R T hyphen B I T, bilberty, 2, 1.17, 0.83, and 0.415. F R T hyphen P L T, plumcot, 2.1, 1.24, 0.86, and 0.410. F R T hyphen B L N, blackcurrent, 2, 1.18, 0.82, and 0.410. F R T hyphen P I L, pineapple, 0.77, 0.46, 0.31, and 0.403. F R T hyphen P L M, plumprune, 1.31, 0.77, 0.54, and 0.412. F R T hyphen C U N, currant, 1.75, 1.04, 0.71, and 0.406. F R T hyphen P E A, pear, 1.83, 1.07, 0.76, and 0.415. F R T hyphen P A Y, papaya, 1.06, 0.63, 0.43, and 0.406. F R T hyphen C H I, chico fruit, 1.75, 1.03, 0.72, and 0.411. F R T hyphen M I I, miracle fruit, 2.05, 1.2, 0.85, and 0.415. F R T hyphen L O A, Longan, 1.85, 1.1, 0.75, and 0.405. F R T hyphen L I M, lime, 0.96, 0.57, 0.39, and 0.406. F R T hyphen C U E, cucumber, 1.82, 1.09, 0.73, and 0.401. F R T hyphen K I I, kiwifruit, 2.32, 1.37, 0.95, and 0.409. F R T hyphen J A U, jambul, 1.95, 1.13, 0.82, and 0.421. F R T hyphen J A I, jackfruit, 0.63, 0.37, 0.26, and 0.413. F R T hyphen J A B, jabuticaba, 0.89, 0.52, 0.37, and 0.416. F R T hyphen G U V, guava, 0.94, 0.56, 0.38, and 0.404. F R T hyphen G R I, graperaisin, 1.25, 0.74, 0.51, and 0.408.

❌
✅
❌
❌
Переглянути це питання

What is the 50th percentile in the chart shown below?

The figure shows a box plot. The vertical axis shows the sales price ranging from $0 to $3,000 in increments of $500. The lower whisker has a value of $19.00. The first quartile has a value of $59.00. The median or the second quartile has a value of $149.00. Inside the box the mean value is X$624.40. The third quartile has a value of $949.00. The upper whisker has a value of $1,799.00. The outlier above the upper whisker has a value of $2,299.00. The outlier and maximum value is $2,599.00.

✅
❌
❌
❌
Переглянути це питання

A diagram showing interrelationships between two or more variables is called a ________.

❌
❌
❌
✅
Переглянути це питання

Хочете миттєвий доступ до всіх перевірених відповідей на moodle.polytechnic.bh?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!

Browser

Додати до Chrome

TelegramInstagramTikTokQuestion Bank
Умови використанняЗв'яжіться з нами