ADC B-Bit Quantizer of Sinusoidal Signal

ADC b-bit Quantizer of sinusoidal signal.Consider the following worksheet that shows ten
samples of a one-period sinusoidal waveform in Column B that has been matched to a b-bit
quantizer with Δ=1 and b specified in B1.The waveform amplitude that is matched to the
quantizer is computed in D1.Column C computes the quantizer level.Column D computes the
b-bit code using the Excel formula that converts a decimal value to its b-bit binary value.
a.What is the Excel formula in D1?
b.What is the Excel formula in B7?
c.What is the Excel formula in C7?
d.What is the Excel formula in D7?
$$\begin{array} { | c | c | c | c | c | } \hline & \text { A } & \text { B } & C & D \\\hline 1 & \mathrm {~b} = & 6 & \mathrm {~A} = & 63 \\\hline 2 & & & & \\\hline 3 & \mathrm { i } & \mathrm { s } _ { \mathrm { i } } & \mathrm { sq } & \mathrm { b } \text {-bit code } \\\hline 4 & 0 & 31.5 & 31 & 011111 \\\hline 5 & 1 & 50.0 & 50 & 110010 \\\hline 6 & 2 & 61.5 & 61 & 111101 \\\hline 7 & 3 & 61.5 & 61 & 111101 \\\hline 8 & 4 & 50.0 & 50 & 110010 \\\hline 9 & 5 & 31.5 & 31 & 011111 \\\hline 10 & 6 & 13.0 & 12 & 001100 \\\hline 11 & 7 & 1.5 & 1 & 000001 \\\hline 12 & 8 & 1.5 & 1 & 000001 \\\hline 13 & 9 & 13.0 & 12 & 001100 \\\hline\end{array}$$