Market Sector Analysis

You are a financial analyst for a consulting firm. Your task is to help clients understand how companies from different sectors perform relative to one another. You are given two datasets in Excel:

$1-$ Complete the table that includes the Company Name, Sector, Market Cap, and $4-$week Change $(\backslash \%)$ for the Tech and Financials Companies.

$2-$ Based on the table you completed, find the average $\backslash (4-\backslash )$ week Change $(\backslash \%)$ for the Tech and Financials companies

$($Now would be a good time to save your work$)$

Dataset $1$: Company Information This dataset includes basic information about each company, including the company's name, sector, and market capitalization.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|\}$

$\backslash$hline Company Name & Sector & Market Cap $($in billions$)\backslash \backslash$

$\backslash$hline Alpha Industries & Industrials & $54\backslash \backslash$

$\backslash$hline Beta Financials & Financials & $23\backslash \backslash$

$\backslash$hline Gamma Pharmaceuticals & Healthcare & $76\backslash \backslash$

$\backslash$hline Delta Tech & Technology & $112\backslash \backslash$

$\backslash$hline Zeta Tech & Technology & $91\backslash \backslash$

$\backslash$hline Omega Health & Healthcare & $45\backslash \backslash$

$\backslash$hline Sigma Industries & Industrials & $31\backslash \backslash$

$\backslash$hline Theta Financials & Financials & $85\backslash \backslash$

$\backslash$hline Epsilon Pharma & Healthcare & $62\backslash \backslash$

$\backslash$hline Lambda Tech & Technology & $135\backslash \backslash$

$\backslash$hline Kappa Energy & Energy & $49\backslash \backslash$

$\backslash$hline Rho Retail & Consumer Goods & $29\backslash \backslash$

$\backslash$hline Pi Financials & Financials & $110\backslash \backslash$

$\backslash$hline Nu Health & Healthcare & $33\backslash \backslash$

$\backslash$hline Xi Tech & Technology & $78\backslash \backslash$

$\backslash$hline Omicron Industries & Industrials & $40\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Dataset $2$: Market Performance Data This dataset includes information about each company's $4-$week percentage change in stock price.

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|\}$

$\backslash$hline Company Name & $4-$week Change $(\backslash \%)\backslash \backslash$

$\backslash$hline Alpha Industries & $1\mathrm{.}8\backslash \backslash$

$\backslash$hline Beta Financials & $0\mathrm{.}9\backslash \backslash$

$\backslash$hline Gamma Pharmaceuticals & $2\mathrm{.}3\backslash \backslash$

$\backslash$hline Delta Tech & $-0\mathrm{.}7\backslash \backslash$

$\backslash$hline Zeta Tech & $1\mathrm{.}4\backslash \backslash$

$\backslash$hline Omega Health & $0\mathrm{.}6\backslash \backslash$

$\backslash$hline Sigma Industries & $1\mathrm{.}1\backslash \backslash$

$\backslash$hline Theta Financials & $0\mathrm{.}4\backslash \backslash$

$\backslash$hline Epsilon Pharma & $2\mathrm{.}8\backslash \backslash$

$\backslash$hline Lambda Tech & $-1\mathrm{.}2\backslash \backslash$

$\backslash$hline Kappa Energy & $1\mathrm{.}9\backslash \backslash$

$\backslash$hline Rho Retail & $0\mathrm{.}7\backslash \backslash$

$\backslash$hline Pi Financials & $1\backslash \backslash$

$\backslash$hline Nu Health & $-0\mathrm{.}5\backslash \backslash$

$\backslash$hline Xi Tech & $0\mathrm{.}3\backslash \backslash$

$\backslash$hline Omicron Industries & $1\mathrm{.}6\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{|$c$|$l$|$l$|$l$|\}$

$\backslash$hline Company Name & Sector & Market Cap $($in billions$)$ & $4-$week Change $(\backslash \%)\backslash \backslash$

$\backslash$hline Delta Tech & & & $\backslash \backslash$

$\backslash$hline Zeta Tech & & & $\backslash \backslash$

$\backslash$hline Lambda Tech & & & $\backslash \backslash$

$\backslash$hline Xi Tech & & & $\backslash \backslash$

$\backslash$hline Beta Financials & & & $\backslash \backslash$

$\backslash$hline Theta Financials & & & $\backslash \backslash$

$\backslash$hline Pi Financials & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|\}$

$\backslash$hline Company Type & Average $4-$week Change $(\backslash \%)\backslash \backslash$

$\backslash$hline Technology & $\backslash \backslash$

$\backslash$hline Financials & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$